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
- 3860 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pooja
Watch Out this link:
https://www.youtube.com/watch?v=zKNVn9Rhn5o
It is similar to the question posted
| Is This Answer Correct ? | 0 Yes | 0 No |
what is mean by complex business rule ?
What are the data movement modes in informatcia?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
what is unit testing?tell me proceedure
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
How would you join a node to the already existing domain?
What is the difference between Bulk Load and Normal Load
Is it possible to use a client with different version than that of its Informatica server?
any body can say about all versions of informatica ?how many versions ?
Explain the pipeline partition with real time example?
Explain the types of transformations?
Teradata 
