Urgent Help Needed On Informatica

[jambalaksipamba]

baa nenu flat file create cheyali kakapote danilo header and footer include cheyali header lo emo filename|presentdate ravali and footer lo emo filename|no of rows in file|sum of all moneyfeild column ila ravali ante emi cheyali

my server is in windows unix work avadu

[Tesla]

Header and footer values ni verega caliculate cheyyi, data and header and footer ni merger cheyyadaniki union vadu,(union cheyyadaniki all inputs should have same data types so header and footer ni design chesi nappudu use all columns from original data but oka 2 or 3 columns llo neku kavalisina data petti migathavi blank cheyyu) and also oka sudo column create chesukoo header ki a sudo column 1 value ivvu and footer ki 10 ivvu and rest of data ki 5 ivvu, txt fie ki output icchhe mundhu order by a sudo column use cheyyu so order lo vsthayi

[ganesh]

header ki oka expression aa taruvata aggregator trailer ki oka expression oka aggregator detail ki oka expression....
three columns common ga pettuko
okati
filename
sort(header exp A ni define cheyyu,detail lo B trailer lo C ani)
data
note:detail columns ni concatenate chesi oka port cheyyu, header columns ni concatenate chesi oka port cheyyu alaage trailer)

then use union(painna cheppina three ports with 3 groups header detail trailer create cheyyu)
sorter
then target
filename
O/p

[jaffanajeffada]

good post

[Terminator II]

[quote name='ganesh' timestamp='1347210953' post='1302451396']
header ki oka expression aa taruvata aggregator trailer ki oka expression oka aggregator detail ki oka expression....
three columns common ga pettuko
okati
filename
sort(header exp A ni define cheyyu,detail lo B trailer lo C ani)
data
note:detail columns ni concatenate chesi oka port cheyyu, header columns ni concatenate chesi oka port cheyyu alaage trailer)

then use union(painna cheppina three ports with 3 groups header detail trailer create cheyyu)
sorter
then target
filename
O/p
[/quote]

GP