1.

What Is The Difference Between Active Transformations And A Passive Transformation In Informatica? Give Example Transformations For Each?

Answer»

Active transformation:

It is a process it changes the NUMBER of rows that have GONE through the mapping. This process is called as Active transformation

Some of the Active transformations are:

  • Sorter transformations
  • Filter transformations
  • Joiner transformations
  • Rank transformations
  • Router transformations

etc.

Passive transformation:

It is a process where it doesn’t CHANGE the number of rows that have gone through the mapping. 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

Etc.

Active transformation:

It is a process it changes the number of rows that have gone through the mapping. This process is called as Active transformation

Some of the Active transformations are:

etc.

Passive transformation:

It is a process where it doesn’t change the number of rows that have gone through the mapping. This process is called as Passive transformation.

Some of the Passive transformations are:

Etc.



Discussion

No Comment Found