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 for New Rows

Data Flow for New Rows

The following table describes the data flow for new rows. For each new row in the source, this data flow creates a primary key, optionally notes the load date, and inserts the row into the target:
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, if you selected the Mapping Wizard Effective Date option. Otherwise, passes values to the target to populate the PM_PRIMARYKEY column.
EXP_KeyProcessing_InsertNew
Expression
Created only when you select the Effective Date option in the Mapping Wizard.
Passes generated values to the target to populate the PM_PRIMARYKEY column in the target.
Uses
SYSDATE
to populate the PM_EFFECT_DATE column in the target, indicating when the row is created.
T_
TargetName
Target Definition
Instance of the target definition for new rows to be inserted into the target.


Updated June 25, 2018