Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table.
can any tell me procedure.
- 2 Answers
- 7801 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / jay
SCR-->SQ-->AGGR-----
| |
| v TRG 1
--------->RTR--> /
/ \
SEQ TRG 2
First get the count of records using Aggr t/r
and use this result in router t/r and have
router condition as SEQ < (Count / 2) for TRG 1
and default for TRG 2
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is a surrogate key?
How identifying bottlenecks in various components of informatica and resolving them?
Why sorter is an active transformation?
Which version configuration tool used in ur project?
scenario where i can use only concurrent execution of workflow.
How can we use mapping variables in informatica?
What does role playing dimension mean?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is rank transformation in informatica
Did u used latest transformations of 8.6.0? for what?
What is persistent lookup cache?
What is a rank transform?
How you can differentiate between connected lookup and unconnected lookup?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
