zafar

• Jun 18th, 2006

 

Active Transformation is one which can change the number of rows i.e, input rows and output rows might not match. Number of rows coming out of Union transformation might not match the incoming rows.

Zafar

saivenkatesh

 Profile Answers by saivenkatesh 

• Jun 23rd, 2006

 

Active Transformation: the transformation that change the no. of rows in the Target.

 Source (100 rows) ---> Active Transformation ---> Target (< or > 100 rows)

Passive Transformation: the transformation that does not change the no. of rows in the Target.

      Source (100 rows) ---> Passive Transformation ---> Target (100 rows)

Union Transformation: in Union Transformation, we may combine the data from two (or) more sources. Assume, Table-1 contains '10' rows and Table-2 contains '20' rows. If we combine the rows of Table-1 and Table-2, we will get a total of '30' rows in the Target. So, it is definetly an Active Transformation.

retech

 Profile Answers by retech Questions by retech

• Jun 23rd, 2006

 

thank u very munch sai venkatesh for ur answer but inthat case look up transformation should be an active transformation but it is a passive transformation .

madugula

• Jun 28th, 2006

 

Active transformation number of records passing through the transformation and their rowid will be different, it depends on rowid also.

sandeep

• Jun 28th, 2006

 

This is a type  of passive transformation which is responsible for merging the data comming from different sources. the union transformation  functions very similar to union all statement in oracle.

sakthivel

• Jun 30th, 2006

 

Hi Saivenkatesh ur answer is very nice thanking you.

Motilal

 Profile Answers by Motilal 

• Jun 30th, 2006

 

Ya since the Union Trnsformation may lead a change to the no of rows incoming, it is definitely an active type.

In the other case, Look-up in no way can change the no. of row that are passing thru it. The transformation just looks to the refering table. The no. of records increases or decreases by the transformations that follow the look-up transformation.

e

• Jun 30th, 2006

 

Are you sure that Lookup is a passive trasformation

Motilal

 Profile Answers by Motilal 

• Jul 11th, 2006

 

Ya, Surely Lookup is a passive one

nandu214

 Profile Answers by nandu214 

• Jun 22nd, 2008

 

Hi u are saying source rows also 10+20=30 it passes all 30 rows to the target according to active definition while it passes the rows to the next t/r should be d/t but it passes all 30 rows.

I am confusing here can anyone clear me in detail. thanks in advance 

sureshbesra

 Profile Answers by sureshbesra 

• Nov 30th, 2009

 

Input rows is (10+20=)30 and output rows also 30, so how come it can be active tranformation.

May be I guess union transformatio merges multiple input groups to a single output group,so it is active active transformation, but still in this case no. of rows don't change

mani

• Sep 7th, 2011

 

yes, union is active as it merges the result set from the two different table.

where as look is passive transformation because where the look up condition is met, it returns the value.
if the condition is met it returns default value for connected lookup and null for the unconnected lookup.

mani

• Sep 7th, 2011

 

union returns the distinct values when you merge the result set from 2 different tables.so duplicates are not allowed, so it is active transformation

Narendra

• Sep 10th, 2011

 

Union will give duplicate records also. Main reason is it is derived from custom transformation when union used with custom transformation at that time it works as active transformation. if any transformation have active functionality definitely that transformation is active.

Thanks
@Nandu