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.
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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are active and passive transformations?
What is the use of transformation?
How to load the data from people soft hrm to people soft erm using informatica?
What is parallel processing in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Partition, what happens if the specified key range is shorter and longer
What is lookup change?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Under which circumstances, informatica server creates reject files?
What is dimensional table? Explain the different dimensions.
What is a sequence generator transformation?
what is song in infrmatica...?
What is decode in informatica?
Explain the different lookup methods used in informatica?