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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What does command task mean?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is meant by a domain?
Differentiate between reusable transformation and mapplet.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is an unconnected transformation?
How to use procedural logic inside infromatica?
wat are deployement groups in informatica, how it will be used for developers
What are the different ways to implement parallel processing in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the different lookup cache(s)?
Explain dynamic target flat file name generation in informatica
Explain about Informatica server process that how it works relates to mapping variables?
What is lookup change?