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

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


What is persistent lookup cache?

0 Answers  


every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,


How to load a relational source into file taget?

2 Answers  






What are the different threads in DTM process?

2 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


What is the Difference between SetVariable and setmaxvariable in informatica?

1 Answers  


tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


What are limitations of joiner transformation?

2 Answers   Exilant, TCS,


Categories