Designer Guide

Back Next

Data Flow for Changed Rows

For each changed row in the source, this data flow marks the row for update and overwrites the corresponding row in the target.

The following table describes the data flow for changed rows:

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 . Passes changed rows to UPD_ChangedUpdate.
UPD_ChangedUpdate	Update Strategy	Uses DD_UPDATE to overwrite corresponding rows in the target.
T_ TargetName 1	Target Definition	Instance of the target definition allowing changed rows to be overwritten in the target.