if soource is having 10 records how will u insert 20
records to target

Answer Posted / priyank

Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).

SQ1 --> UNION --> EXP --> Target
SQ2

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of lookup transformation?

820


Could you explain what is enterprise data warehouse?

738


What is option by which we can run all the sessions in a batch simultaneously?

854


What is the difference between stop and abort in informatica

856


How an expression transformation differs from aggregator transformation?

803






What is the reusable transformation?

811


What is transformation?

864


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1825


What do you understand by a term domain?

851


Enlist few areas or real-time situations where informatica is required.

798


What is mapping debugger?

733


How do you load alternate records into different tables through mapping flow?

1543


What are the different ways to implement parallel processing in informatica?

1078


How to differentiate between the active and passive transformations?

816


Why union transformation is an active transformation?

839