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

How do you set a varible in incremental aggregation

1430


Tell me about Propagate functions in informatica

514


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

587


What are the different components of powercenter?

572


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

10265






r u done any partitions in ur project?

1388


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5229


Whats the difference between informatica powercenter server, repositoryserver and repository?

661


How an expression transformation differs from aggregator transformation?

612


What are the advantages of using informatica as an etl tool over teradata?

558


What happens when a session fails and you click on recover?

646


server hot-ws270 is connect to Repository B. What does it mean?

1843


What are batches?

607


How can we use mapping variables in informatica?

586


How can repository reports be accessed without sql or other transformations?

714