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 / vinod kumar
copy the source for 3 times then total 4 sources will be
there in your mapping and move all sources to the target you
will get 4 times of same data in target
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is informatica? Why do we need it?
What is a joiner transformation?
What is a transaction control transformation?
What is the use of source qualifier?
What is an aggregator transformation?
What is different between the data warehouse and data mart?
design of staging area?
How to extract sap data using informatica?
EXL informatica Questions
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Do you find any difficulty while working with flat files as source and target?
What is the sequence generator transformation in informatica?
Why filter transformation is an active one?
What are the uses of etl tools?