Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
Answer Posted / krish
i really did'nt understand one thing if the target has PK on
it any of the methods specified above will not work.
let us think there is no PK on our T/G
the also all the methods above is wast of time
just run the secession 4 times
but the main thing (don't enable truncate the target table
option) .,.
if he say other than this option
then
Sai.masarapu.chowdary ans is good we can go with that.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
What are the tasks that can be performed using sq?
How can a transformation be made reusable?
Explain in detail scd type 2 through mapping.
What is the use of target designer?
What is data movement mode in Informatica and difference between them?
r u done any partitions in ur project?
What is the use of code page?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is sq transformation?
What is the need for an etl tool?
What is a joiner transformation and why it is an active one?
Is it possible to define a single node as a Gateway node as well as worker node?
What is an aggregator transformation?
Which version configuration tool used in ur project?