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
list out all the transformations which use cache?
what is the complex transformation you used in informatica
Explian the Process of deployment groups in informatica
What is the function of union transformation?
On which transformations you created partitions in your project?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what is size of u r database?
Did u used latest transformations of 8.6.0? for what?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the different clients of powercenter?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is diff b/t sorter t/r and agg have the option sorter property...
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the types of schemas we have in data warehouse.
What is rank transformation?