Informatica Data Warehousing Interview Question:

Is union Transormation is Active transformation?

Submitted by: Administrator

By Definiation, Active transformation is the transformation that changes the number of rows that pass through it...in union transformation the number of rows resulting from union can be (are) different from the actual number of rows.

As we are combining results of two select queries using Union Tr Most probably no of rows increases.So it is An Active Tr.
Submitted by: Administrator