PowerCenter
- PowerCenter 10.4.1
- All Products
Transformation Name | Transformation Type | Description |
---|---|---|
FIL_InsertChangedRecord | Filter | Uses the following filter condition to filter out any rows that are not marked changed: ChangedFlag . Passes changed rows to UPD_ChangedInserts. |
UPD_ChangedInserts | Update Strategy | Uses DD_INSERT to insert rows to the target. |
EXP_KeyProcessing_InsertChanged | Expression | Uses the following expression to increment the existing primary key by one: PM_PRIMARYKEY + 1 . Creates a current flag of 1 for each row to populate the PM_CURRENT_FLAG column in the target. |
T_ TargetName 2 | Target Definition | Instance of the target definition allowing changed rows to be inserted into the target. |