Search

Designer Guide

Designer Guide

10.4.1
- 10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

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 creates a new primary key, sets the beginning of the effective date range, and inserts the row into the target:

Transformation Name	Transformation Type	Description
FIL_InsertChangedRecord	Filter	Uses the following filter condition to filter out any rows from EXP_DetectChanges that are not marked changed (TRUE): ChangedFlag . Passes changed rows to UPD_ChangedInserts.
UPD_ChangedInserts	Update Strategy	Uses DD_INSERT to insert rows to the target.
SEQ_GenerateKeys (same Sequence Generator as above)	Sequence Generator	Generates a value for each changed row written to the target, incrementing values by 1. Passes values to EXP_KeyProcessing_InsertChanged.
EXP_KeyProcessing_InsertChanged	Expression	Passes generated values to the target to populate the PM_PRIMARYKEY column in the target. Uses SYSDATE to populate the PM_BEGIN_DATE column in the target, marking the beginning of the effective date range.
T_ TargetName 2	Target Definition	Instance of the target definition allowing changed rows to be inserted into the target.

Understanding the Mapping

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.