PowerCenter
- PowerCenter 10.4.0
- 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_CalcToDate | Expression | Uses SYSDATE to update the PM_END_DATE column in the existing target row, marking the end of the effective date range. |
T_ TargetName 3 | Target Definition | Instance of the target definition allowing updates to existing rows in the target. |