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

list out all the transformations which use cache?

691


what is degenerated dimension?

3160


What are the different transaction levels available in transaction control transformation?

679


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

654


In informatics server which files are created during the session rums?

639






Describe data concatenation?

576


What are active transformations.

1190


What is the Rank index port in Rank transformation?

672


tell me about your project functionality

1870


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1519


What are the data movement modes in informatica?

707


Which is the t/r that builts only single cache memory?

714


Is it possible to create multiple domains on a single Informatica server?

760


Why update strategy and union transformations are active?

594


Whats there in global repository

1272