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.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to delete duplicate row using informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is sequence generator transformation in informatica?
What will be the approach?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is option by which we can run all the sessions in a batch simultaneously?
How to load data in informatica ?
What is native users?
What is dimensional table? Explain the different dimensions.
What do you mean by worklet?
Is it possible to define a single node as a Gateway node as well as worker node?
How can we create index after completion of load process?
Informatica Checkpoints