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 / 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
can you please explain me pre session and post session options?
whats the logic to load the lower level of granularity of data to fact table.
What are the popular informatica products?
Define Pmrep command?
Explain transaction control transformation in informatica
How do you load unique records into one target table and duplicate records into a different target table?
How to create a non-reusable instance of reusable transformations?
How can you generate reports in informatica?
What is a filter transformation and why it is an active one?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
list out all the transformations which use cache?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is decode in static cache?