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
How do you set a varible in incremental aggregation
Tell me about Propagate functions in informatica
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?
What are the different components of powercenter?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
r u done any partitions in ur project?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How an expression transformation differs from aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
What happens when a session fails and you click on recover?
server hot-ws270 is connect to Repository B. What does it mean?
What are batches?
How can we use mapping variables in informatica?
How can repository reports be accessed without sql or other transformations?