As union transformation gives UNION ALL output, how you will get the UNION output?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,


What is difference between stored procedure transformation and external procedure transformation?

2 Answers  


TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


what is diffrence b/w joner and union transfermation

6 Answers  






Do you have knowledge in ralph kimball methodology

1 Answers  


what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  


how we load the data from source to staging area

4 Answers   TCS,


What are the challenges of Dataware housing in the future?

2 Answers   HP,


What are the session parameters?

3 Answers  


What is native users?

0 Answers  


How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,


Categories