Answer Posted / sharad sharma
The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.
| Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
What is lookup change?
Mention few power centre client applications with their basic purpose?
which one is better performance wise joiner or look up
what is the difference between informatica6.1 and infomatica7.1
Write the program through which the records can be updated?
How many dimensions are there in informatica?
What are multi-group transformations?
What is a snowflake schema?
What are the different types of repositories created using informatica?
How might you approve all mappings in the archive all the while?
What are the types of data warehouses?
What are the differences between a connected lookup and unconnected lookup?
What are the issues you have faced in your project? How did you overcome those issues?
How can we improve session performance in aggregator transformation?