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


Please Help Members By Posting Answers For Below Questions

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

1534


What does command task mean?

614


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

1700


What is meant by a domain?

630


Differentiate between reusable transformation and mapplet.

575






Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

739


What is an unconnected transformation?

667


How to use procedural logic inside infromatica?

636


wat are deployement groups in informatica, how it will be used for developers

1257


What are the different ways to implement parallel processing in informatica?

865


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


What is the different lookup cache(s)?

614


Explain dynamic target flat file name generation in informatica

650


Explain about Informatica server process that how it works relates to mapping variables?

623


What is lookup change?

618