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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the cumulative sum and moving sum?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is joiner change?
Briefly explain the aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?
what is informatica metadata?
What are the different types of repositories created using informatica?
When do you use sql override in a lookup transformation?
where to store informatica rejected data?
What is sequence generator transformation in informatica?
How to extract the informatica rejected data?
What is the difference between a connected look up and unconnected lookup?