Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Data Flow to Update Existing Rows

Data Flow to Update Existing Rows

The following table describes the data flow for existing rows. For each changed row in the source, this data flow updates the corresponding row in the target, copying existing data into
previous
columns, updating new data, and optionally notes the date the row changed:
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
.
Uses values returned from LKP_GetData to populate
previous
columns.
Passes changed rows to UPD_ChangedUpdate.
UPD_ChangedUpdate
Update Strategy
Uses
DD_UPDATE
to update existing rows in the target.
Passes updated rows to EXP_EffectiveDate_InsertChanged, if you selected the Mapping Wizard Effective Date option. Otherwise, passes updated rows to the target.
EXP_EffectiveDate_InsertChanged
Expression
Created only when you select the Effective Date option in the Mapping Wizard.
Uses
SYSDATE
to populate the PM_EFFECT_DATE column in the target, indicating when the row is updated.
T_
TargetName
2
Target Definition
Instance of the target definition allowing updates to existing rows in the target.


Updated June 25, 2018