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

What is an aggregator transformation?

843


What is workflow? What are the components of workflow manager?

933


What is rank transformation in informatica

940


What are active transformations.

1415


What are the differences between a connected lookup and unconnected lookup?

838


What is a mapplet/worklet in informatica?

936


What is the sequence generator transformation in informatica?

877


What is joiner change?

916


How many ways are there to create ports?

962


Difference between Data and Index Caches?

881


Explian the Process of deployment groups in informatica

830


update strategy transformation in informatica

847


What can we do to improve the performance of informatica aggregator transformation?

859


What is powercenter on grid?

948


What is the difference between Active and Passive transformation?

871