| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Union Transformation
Answer: Why Union transformation is active while it returns same number of rows as in the sources? |
| July 07, 2008 07:09:00 |
#3 |
| Rashmirekha |
Member Since: November 2007 Total Comments: 5 |
RE: Union Transformation
|
Hi,
Please make a note that there is no option available in a Union transformation to handle duplicates.It does a 'UNION ALL'. If handling of duplicates is the requirement then Sorter can be used. |
| |
Back To Question | |
