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 is persistent lookup cache?
What is the sql query overwrite in source qualifier in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
What is the advantage of informatica?
What is the function of aggregator transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
how to create user defined function (udf) in informatica
What is the reusable transformation?
What is sorter transformation?
What are the databases that informatica can connect to windows?
How to configure mapping in informatica?
Where are the source flat files kept before running the session?
What are the tasks that can be performed using sq?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Do you find any difficulty while working with flat files as source and target?