kirankumarvema

• Jul 22nd, 2006

 

By using union transformation we can eleminate some rows....so this is active transformation.bye

krishna

• Jul 23rd, 2006

 

Pls explain more. we are doing the union.how the union is eliminating the some rows.

Bala

• Jul 24th, 2006

 

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.

dsr

• Jul 26th, 2006

 

union is active becoz it eliminates duplicates from the sources

manasa

• Jul 27th, 2006

 

Heloo Msr your answer is wrong.Union is not eliminating the duplicate rows.If anybody knows please give me reason. All are giving the above answers are not supporting that question.Don't give the active transofrmation defination.I want exact reasons.

srisailu

 Profile Answers by srisailu 

• Jul 31st, 2006

 

hi,

  We can merge multiple source qualier query records in union trans at same time , its not like expresion trans (each row). so we can say it is active.

Uma Bojja

 Profile Answers by Uma Bojja 

• Aug 29th, 2006

 

Hi,

Union Transformation is a active transformation because it changes the number of rows through the pipeline.

It normally has multiple input groups to add on it compare to other transformation.Before union transformation was implement the funda on number of rows was right i.e before 7.0 but now its not the exact benchmark to determine the active transformation

Thanks

Uma

Ravi

• Sep 25th, 2006

 

 Hi,

     Union also Active tranformation.because it eliminates duplicate rows

   When you select distinct option in union properties tab.

h02kkvel

 Profile Answers by h02kkvel 

• May 15th, 2008

 

Hi all,
         some people saying that a union T/R eliminates duplicates. but it is woring . As of now it wont eliminate duplicates.

The union T/R is active and also passive depends upon the property "is active"  which is present at union T/R properties tab.  this Specifies whether this transformation is an active or a passive transformation.  When you enable this option, the transformation can generate 0, 1 or more output rows for each input row.  Otherwise, it can generate only 0 or 1 output row for each input row.

but this property is disabled in informatica 7.1.1.  I think it may developed in future.

regards,
kiran