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
What is a pre-defined event and user-defined event?
How are the sources and targets definitions imported in informatica designer?
what is index?how it can work in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is degenerated dimension?
How can you differentiate between powercenter and power map?
Explain the different kinds of facts.
What are the types of lookup transformation?
What is option by which we can run all the sessions in a batch simultaneously?
what is SDLC way of code development?
How might you approve all mappings in the archive all the while?
Briefly describe lookup transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
To import the flat file definition into the designer where should the flat file be placed?