I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance

Answer Posted / jayesh

Use target load plan.
Option is available in mappping designer.

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sequence generator transformation in informatica?

639


What are the different types of repositories created using informatica?

671


What if the source is a flat-file?

602


what is INFORMATICA TESTING process

1851


What are the main issues while working with flat files as source and as targets ?

668






What is a pre-defined event and user-defined event?

587


What do mean by local and global repository?

712


What is meant by LDAP users?

705


Explain about Informatica server process that how it works relates to mapping variables?

640


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8591


While importing the relational source definition from the database, what are the metadata of source that will be imported?

799


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10288


Target increases every day even though no new record was inserted

1118


What is the difference between a repository server and a powerhouse?

829


How are the sources and targets definitions imported in informatica designer?

689