Designer Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5
- 10.4.1
- 10.4.0

Back Next

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.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Data Flow to Update Existing Rows

Data Flow to Update Existing Rows