Answer Posted / 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 View All Answers
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is a sorter transformation?
differences between service based and product based?
Make a note of the quantity vaults made in informatica?
How to do the error handling of if ur source is flatfiles?
What is the use of target designer?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the static cache and dynamic cache in informatica?
What is the meaning of up gradation of repository?
What does command task mean?
Explain lookup transformation is active in informatica
What is blocking transformation?
According to his methodology what all you need before you build a datawarehouse
What is the Process to creating lookup transformation in informatica
What is dynamic cache?