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


Please Help Members By Posting Answers For Below Questions

differences between service based and product based?

1575


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1509


Different qualification between a related rotate toward the sky and isolates look upward?

562


How to do unit testing in informatica? How to load data in informatica ?

658


What is complex mapping?

646






permutations of mapplet

2048


What is data caches/ index caches?

621


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1641


How can we store previous session logs?

577


if we have a delimiters at unwanted places in a flat file how can we over come those.

1576


What is difference between a gateway node and worker node?

637


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

639


Enlist the various types of transformations.

566


What do you understand by SOA of Informatica?

596


What is native users?

730