Pages

Active Transformation in Informatica

I see many people still confused with the definition of the active transformation. Here is the exact definition:

An active transformation can perform any of the following actions:
  • Change the number of rows that pass through the transformation. For example, the Filter transformation is active because it removes rows that do not meet the filter condition. All multi-group transformations are active because they might change the number of rows that pass through the transformation.
  • Change the transaction boundary. For example, the Transaction Control transformation is active because it defines a commit or roll back transaction based on an expression evaluated for each row.
  • Change the row type. For example, the Update Strategy transformation is active because it flags rows for insert, delete, update, or reject.

No comments:

Post a Comment