GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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?


April 04, 2008 04:43:54 #1
 suvomoy chakraborty Database Expert  Member Since: April 2006    Total Comments: 1 

RE: Union Transformation
 

Union Transformation in general does not allow duplicate rows. If the sources contain duplicate rows then the effective count of rows after union certainly will be reduced. That should be one of the reasons for it being an active transformation.

A question may be raised regarding a situation where the sources do not contain any duplicates. The answer should be even in that scenario the transformation's inherent ability to check for the duplicate rows will remain intact. Just like a filter transformation not changing the row count because the filter condition was not either entirely true or entirely false for all of the rows.

     

 

Back To Question