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
- 18842 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
When do you use sql override in a lookup transformation?
What is deployment group?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How we can create indexes after completing the load process?
explain abt ur project architecture?
How many transformations can be used in mapplets.
What is the use of an aggregator cache file?
What do you understand by SOA of Informatica?
What is aggregator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the new features of informatica 9.x at the developer level?
Can we get 1st record through Informatica(without sequence number).
What are 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 primary and backup node?
