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
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
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain the difference between a data warehouse and a data mart?
What is event and what are the tasks related to it?
According to his methodology what all you need before you build a datawarehouse
How might one distinguish in the case of mapping is right or not without associating session?
How to extract sap data using informatica?
What is informatica etl tool?
What is dimensional table?
What do you understand by term role-playing dimension?
What is an Integration service in Informatica?
Enlist some properties of sessions.
Write the prerequisite tasks to achieve the session partition?
What are the differences between source qualifier and joiner transformation?
What are the designer tools for creating transformations?
What is main use of mapplet?