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
can anyone explain me about retail domain project in informatica?
What is a sequence generator transformation?
what is informatica metadata?
Explain the different lookup methods used in informatica?
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.
What are the new features of informatica 9.x in developer level?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is an expression transformation in informatica?
What are some examples of informatica etl programs?
What are the new features of informatica 9.x at the developer level?
How big was your fact table
my source is junk data how will u remove that junk data by using unix please any one replay me
Write the advantages of partitioning a session?
What differs when we choose the sorted input for aggregator transformation?
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