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
What are the types of lookup transformation?
Could you explain what is enterprise data warehouse?
What is option by which we can run all the sessions in a batch simultaneously?
What is the difference between stop and abort in informatica
How an expression transformation differs from aggregator transformation?
What is the reusable transformation?
What is transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What do you understand by a term domain?
Enlist few areas or real-time situations where informatica is required.
What is mapping debugger?
How do you load alternate records into different tables through mapping flow?
What are the different ways to implement parallel processing in informatica?
How to differentiate between the active and passive transformations?
Why union transformation is an active transformation?