explain abt union t/r?



explain abt union t/r?..

Answer / suraj kedia

A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.

It is an active transformation.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is meta data and system catalog?

2 Answers  


WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


comonly how meny mappings r there in Banking projects?

1 Answers  


WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,






What happens if we dont select data driven option?

2 Answers   Zensar,


Why we need XMLs?

3 Answers   IBM,


What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


What is the use of source qualifier?

0 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


can we create index and drop index in exsisting table while using infomatica

4 Answers  


Categories