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. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Data Flow for Changed Rows

Data Flow for Changed Rows

The following table describes the data flow for changed rows. For each changed row in the source, this data flow increments the existing primary key by 1, flags the row current, and inserts it into the target:
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.

0 COMMENTS

We’d like to hear from you!