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
- 10 Answers
- 17629 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / anup shukla
Create router transformation with 4 different ports.
and set condition true for all the four ports.
and take it to the target from union trans.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can a transformation be made reusable?
Global and Local shortcuts. Advantages.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the function of union transformation?
How to load last n records of file into target table - informatica
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is transformation?
Explain why we use partitioning the session in informatica?
how to load dimension table and fact table. plz tell me the steps.
Enlist the advantages of informatica.
What is xml source qualifier transformation in informatica?
Differentiate between a database and data warehouse?
Difference between Data and Index Caches?
Which transformation should we use to normalise the COBOL and relational sources?
