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 is a dimensional model?
Mention few power centre client applications with their basic purpose?
what is unit testing?tell me proceedure
Explain the shared cache and re-cache?
Explain scd type 3 through mapping.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is union transformation in informatica?
What is native users?
How can we remove the duplicates from flat file source?
How can you define user defied event?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a grid in Informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How we can create indexes after completing the load process?