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?
- 2 Answers
- 3623 Views
- CTS, I also Faced
- E-Mail Answers
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
How to configure mapping in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is rank transformation?
What is xml source qualifier transformation in informatica?
What are the components of Informatica? And what is the purpose of each?
What is meant by lookup transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How does a sorter cache works?
Which version configuration tool used in ur project?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you promote a non-reusable transformation to reusable transformation?
Informatica Checkpoints
What are junk dimensions?
What is Index Caches size?
What does role playing dimension mean?
