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 / mari ilavarasi
Using router transformation we can send half of the records
in one target and rest of the records will be inserted into
another target based on conditions.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is primary and backup node?
Explain the pipeline partition with real time example?
What is a mapplet/worklet in informatica?
Repository user profiles
where to store informatica rejected data?
Difference between Target-based loading and constraint-based loading?
What is the difference between router and filter?
What is expression transformation?
How to create Target definition for flat files?
What are the popular informatica products?
What is transformation?
What is workflow monitor?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
write a query to retrieve the latest records from the table sorted by version(scd)