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
- 18431 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 do you understand by term role-playing dimension?
How can we update a record in the target table without using update strategy?
What is informatica?
Why update strategy and union transformations are active? Explain with examples.
What is resilience time?
Explain the different lookup methods used in informatica?
what is index?how it can work in informatica
What is Index Caches size?
In how many ways we can create ports?
What all join we can perform in LOOKUP transformation?
How big was your fact table
What is native users?
Tell me about MD5 functions in informatica
What is an Integration service in Informatica?
How an expression transformation differs from aggregator transformation?
