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

can anyone explain me about retail domain project in informatica?

7565


What is a sequence generator transformation?

666


what is informatica metadata?

692


Explain the different lookup methods used in informatica?

686


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2383






What are the new features of informatica 9.x in developer level?

645


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

761


What is an expression transformation in informatica?

634


What are some examples of informatica etl programs?

622


What are the new features of informatica 9.x at the developer level?

701


How big was your fact table

1409


my source is junk data how will u remove that junk data by using unix please any one replay me

3356


Write the advantages of partitioning a session?

852


What differs when we choose the sorted input for aggregator transformation?

669


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1764