Database Reference
In-Depth Information
(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 only
allows records as
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
only allows records as
ChangedFlag
to get passed to the
UPD_ChangedInserts
update strategy.
•
Filter
(
FIL_UpdateChangedRecord
): This filters the records that come
from the upstream expression transformation and are marked as
NewFlag
; it
only allows records marked as
ChangedFlag
to pass. For every record marked
as
ChangedFlag
, the filter passes the primary key of the previous version to
the
UPD_ChangedUpdate
update strategy.
•
Update strategy
(
UPD_ForceInserts
): This uses the
DD_INSERT
condition
to insert the data into the
EMPLOYEE_SCD2_FLAG
target instance.
•
Update strategy
(
UPD_ChangedInserts
): This uses the
DD_INSERT
condi-
tion to insert data into target instance
EMPLOYEE_SCD2_FLAG1
.
•
Update strategy
(
UPD_ChangedUpdate
): This uses the
DD_UPDATE
condi-
tion to overwrite the existing
LOCATION
value into the target, which is
EMPLOYEE_SCD2_FLAG2
.
•
Sequence generator
(
SEQ_GenerateKeys
): This generates a sequence of val-
ues for
PM_PRIMARYKEY
for each row marked as
NewFlag
into the target, in-
crementing the value by
1
.
•
Expression
(
EXP_KeyProcessing_InsertNew
): This multiplies
NEXTVAL
generated by the sequence generator by
1000
using the
NEXTVAL*1000
condi-
tion. Note that you can change this number as per your requirement. Using
1000
here means that we can maintain a
1000
history of a particular record. This cre-
ates a current flag of
1
for each
NewFlag
record to load into the
PM_CURRENT_FLAG
column in the target.
•
Expression
(
EXP_KeyProcessing_InsertChanged
): This is used to in-
crement the primary key by
1
using the
PM_PRIMARYKEY + 1
condition. It
also creates a current flag of
1
for each
NewFlag
record to load the
PM_CURRENT_FLAG
column in the target.