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:
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