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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the types of presistent cache in look up tr.
what is degenerated dimension?
Define enterprise data warehousing?
What is the Process to creating lookup transformation in informatica
What is status code in informatica?
wat are deployement groups in informatica, how it will be used for developers
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Tell me about MD5 functions in informatica
Can you use flat files in Mapplets.
differences between service based and product based?
Is it possible to revert a global repository to local one and why?
What is event and what are the tasks related to it?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?