PowerCenter
- PowerCenter 10.4.1
- All Products
Transformation Name | Transformation Type | Description |
---|---|---|
FIL_InsertNewRecord | Filter | Uses the following filter condition to filter out any rows from EXP_DetectChanges that are not marked new (TRUE): NewFlag . Passes new rows to UPD_ForceInserts. |
UPD_ForceInserts | Update Strategy | Uses DD_INSERT to insert rows to the target. |
SEQ_GenerateKeys | Sequence Generator | Generates a value for each new row written to the target, incrementing values by 1. Passes values to EXP_KeyProcessing_InsertNew. |
EXP_KeyProcessing_InsertNew | Expression | Uses the following expression to increment generated values by 1,000: NEXTVAL * 1,000 . Then passes incremented values to the target to populate the PM_PRIMARYKEY column.Creates a current flag of 1 for each row to populate the PM_CURRENT_FLAG column in the target. |
T_ TargetName | Target Definition | Instance of the target definition for new rows to be inserted into the target. |