Search

Designer Guide

Designer Guide

10.4.0
- 10.5.6
- 10.5
- 10.4.1

Back Next

Data Flow for New Rows

Data Flow for New Rows

The following table describes the data flow for new rows. For each new row in the source, this data flow creates a primary key, optionally notes the load date, and inserts the row into the target:

Transformation Name	Transformation Type	Description
FIL_InsertNewRecord	Filter	Uses the following filter condition to filter out any rows from EXP_DetectChanges that are not marked new (TRUE): NewFlag . Passes new rows to UPD_ForceInserts.
UPD_ForceInserts	Update Strategy	Uses DD_INSERT to insert rows to the target.
SEQ_GenerateKeys	Sequence Generator	Generates a value for each new row written to the target, incrementing values by 1. Passes values to EXP_KeyProcessing_InsertNew, if you selected the Mapping Wizard Effective Date option. Otherwise, passes values to the target to populate the PM_PRIMARYKEY column.
EXP_KeyProcessing_InsertNew	Expression	Created only when you select the Effective Date option in the Mapping Wizard. Passes generated values to the target to populate the PM_PRIMARYKEY column in the target. Uses SYSDATE to populate the PM_EFFECT_DATE column in the target, indicating when the row is created.
T_ TargetName	Target Definition	Instance of the target definition for new 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.