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
What you know about transaction control transformation?
What are the advantages of using informatica as an etl tool over teradata?
What's the layout of parameter file (what does a parameter file contain?)?
Define enterprise data warehousing?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Informatica settings are available in which file?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What do you mean by worklet?
Explain Dataware house architecture .how data flow from intial to end?
Is stop and abort are same in informatica?
can anyone suggest best free Talend data integration training online
What is workflow? What are the components of the workflow manager?
What are the different types of repositories created using informatica?
What is rank transformation in informatica
Can we override a native sql query within informatica?