Source
---------
eno , ename, sal
001,ank,1000
002,behe,2000
003,raj,2500
Target
-------
header :DDMMYYYY24MMSS timestamp
body: 001,ank,1000
002,behe,2000
003,raj,2500
footer: count(eno),sum(sal)
how to implement the same in a FF tgt?
Answer Posted / sachin
We can do it in two ways
1)in unix level.write a script to get the footer and header.
2)we can create 3 flows for header ,body and footer and append them one by one
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
During the running session, output files are created by informatica server. Enlist few of them.
In development project what is the process to follow for an etl developer from day1
How you can differentiate between connected lookup and unconnected lookup?
Differentiate between a repository server and a powerhouse?
In which transformation you cannot drag ports into it?
What is persistent lookup cache?
What does role playing dimension mean?
Quickly characterize reusable change?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
can anyone suggest best free Talend data integration training online
What is the meaning of decode in informatica?
What is an aggregator transformation?
How do you use reject loader.
EXL informatica Questions
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?