Database Reference
In-Depth Information
Condition for ChangedFlag : IIF(NOT
ISNULL(PM_PRIMARYKEY) AND
(DECODE(LOCATION,PM_PREV_LOCATION,1,0)=0), TRUE,
FALSE)
Based on the condition, it passes the data to downstream filter transformations.
Filter ( FIL_InsertNewRecord ): This filters the records that come from the
upstream expression transformation and are marked as ChangedFlag ; it allows
records with NewFlag to get passed to the UPD_ForceInserts update
strategy.
Filter ( FIL_InsertChangedRecord ): This filters the records that come
from the upstream expression transformation and are marked as NewFlag ; it al-
lows records with ChangedFlag to get passed to the UPD_ForceInserts
update strategy.
Filter ( FIL_UpdateChangedRecord ): This filters the records that come
from the upstream expression transformation and are marked as NewFlag ; it al-
lows records with ChangedFlag to get passed to the UPD_ChangedUpdate
update strategy. For each row marked as ChangedFlag , it passes the primary
key of the previous version to UPD_ChangedUpdate .
Update strategy ( UPD_ForceInserts ): This uses the DD_INSERT condition
to insert data into the EMPLOYEE_SCD2_DATE_RANGE target instance.
Update strategy ( UPD_ChangedInserts ): This uses the DD_INSERT condi-
tion to insert data into the EMPLOYEE_SCD2_DATE_RANGE1 target instance.
Update strategy ( UPD_ChangedUpdate ): This uses the DD_UPDATE condi-
tion to overwrite the existing LOCATION value into the
EMPLOYEE_SCD2_DATE_RANGE2 target instance.
Sequence generator ( SEQ_GenerateKeys ): This generates a sequence of val-
ues for each new row marked as NewFlag that comes into target, getting incre-
mented by 1 . It passes the value to EXP_KeyProcessing_InsertNew .
Expression ( EXP_KeyProcessing_InsertNew ): This loads the generated
value in the PM_PRIMARYKEY column in the
EMPLOYEE_SCD2_DATE_RANGE target instance. It loads SYSTEMDATE into
the PM_BEGIN_DATE column in the target, marking the start of the record.
Expression ( EXP_KeyProcessing_InsertChanged ): This loads the gen-
erated value in the PM_PRIMARYKEY column in the
EMPLOYEE_SCD2_DATE_RANGE1 target instance. It loads SYSTEMDATE into
Search WWH ::




Custom Search