Why Union transformation is active while it returns same number of rows as in the sources?

prashant.baranwal

 Profile Answers by prashant.baranwal Questions by prashant.baranwal

• Sep 18th, 2010

Union transformation is an active transformation and it does changes the number of records.Suppose source has following columns:Name, School, CollegeABC, SKM, IIT-DXYZ, DAV, IIMThere are total 10 rows...

harikr

 Profile Answers by harikr Questions by harikr

• Dec 1st, 2009

An active transformation can change the number of rows that pass through it. A passive transformation does not change the number of rows that pass through it.Union Transformation does UNION ALL; hence...

Answer Question  Select Best Answer