1.

Differentiate Between The Active Transformations And A Passive Transformation In Informatica?

Answer»

ACTIVE transformation:

Active transformation can simply be interpreted as the process where the number of ROWS which have gone through the mapping gets changed. This process is TERMED as an Active transformation.

Some of the Active transformations include:

  • Sorter transformations
  • Filter transformations
  •  Joiner transformations
  • Rank transformations
  • Router transformations and some other transformations as well.

 Passive transformation:

A Passive transformation can be termed as the process where after having gone through the mapping the number of rows doesn’t get changed. This process is called as Passive transformation.

Some of the Passive transformations are:

  • Expression transformation
  • Sequence Generator transformation
  • Lookup transformation
  • EXTERNAL procedure transformation
  • Output transformation
  • Input transformation and more.

Active transformation:

Active transformation can simply be interpreted as the process where the number of rows which have gone through the mapping gets changed. This process is termed as an Active transformation.

Some of the Active transformations include:

 Passive transformation:

A Passive transformation can be termed as the process where after having gone through the mapping the number of rows doesn’t get changed. This process is called as Passive transformation.

Some of the Passive transformations are:



Discussion

No Comment Found