Search

Designer Guide

Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Data Flow to Update Existing Rows

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 end date of the corresponding row in the target to indicate the existing row is no longer current:

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 . For each changed row, passes the primary key of the previous version to UPD_ChangedUpdate.
UPD_ChangedUpdate	Update Strategy	Uses DD_UPDATE to update existing rows in the target.
EXP_KeyProcessing_UpdateChanged	Expression	For each changed row, sets PM_CURRENT_FLAG to 0 for the previous version in the target, indicating that version is no longer current.
T_ TargetName 3	Target Definition	Instance of the target definition allowing updates to existing rows in the target.

Understanding the Mapping

Watch

Comments

0 COMMENTS

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