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: pls full details
- 8 Answers
- 18162 Views
- L&T, TCS, UnitedHealth Group, Wipro, 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 ? | 9 Yes | 7 No |
Post New Answer View All Answers
What all join we can perform in LOOKUP transformation?
What do think which one is the better joiner or look up?
What is data caches/ index caches?
What is union transformation?
What are the new features of informatica 9.x at the developer level?
What is the session task and command task?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain dynamic target flat file name generation in informatica
How we can use union transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the types of presistent cache in look up tr.
During the running session, output files are created by informatica server. Enlist few of them.
What is the difference between stop and abort in informatica
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
