if soource is having 10 records how will u insert 20
records to target
Answer Posted / sreekanth
select * from table_name
union all
select * from table_name;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain how to import oracle sequence into informatica?
What are session parameters ? How do you set them?
Explain load alternative records / rows into multiple targets - informatica
How might you approve all mappings in the archive all the while?
What is the way to execute pl/sql script using informatica mapping?
Explian the Process of deployment groups in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
In warehouses how many schemas are there?
What are junk dimensions?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Why sorter is an active transformation?
What is transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com