if i am having 10 records in source, i want 20 records in
target...how will you do it

Answer Posted / priyank

Take 2 instances of the same source and join them using
Union transformation which acts as the UNION ALL command of
SQL i.e. it allows duplicates too.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1709


Write the unconnected lookup syntax?

633


What is the need for an etl tool?

611


How can you differentiate between powercenter and power map?

604


What is a mapplet/worklet in informatica?

657






What is meant by pre and post session shell command?

600


What is persistent lookup cache?

576


What is an aggregator transformation?

593


How many transformations can be used in mapplets.

1429


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

549


Explain the difference between a data warehouse and a data mart?

575


What is the difference between source qualifier transformations source filter to filter transformation?

554


How to go to the older version for a mapping?

570


During the running session, output files are created by informatica server. Enlist few of them.

519


Why do you use Mapping Parameter and mapping variable?

1261