PowerCenter
- PowerCenter 10.5
- All Products
Transformation Name
| Transformation Type
| Description
|
---|---|---|
FIL_UpdateChangedRecord | Filter | Uses the following filter condition to filter out any rows from EXP_DetectChanges that are not marked changed (TRUE): ChangedFlag . For each changed row, passes the primary key of the previous version to UPD_ChangedUpdate. |
UPD_ChangedUpdate | Update Strategy | Uses DD_UPDATE to update existing rows in the target. |
EXP_KeyProcessing_UpdateChanged | Expression | For each changed row, sets PM_CURRENT_FLAG to 0 for the previous version in the target, indicating that version is no longer current. |
T_ TargetName 3 | Target Definition | Instance of the target definition allowing updates to existing rows in the target. |