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