Database Reference
In-Depth Information
When we create a mapping using the flag option, the wizard creates the following two ad-
ditional columns in the target table:
•
PM_PRIMARY_KEY
: The wizard generates the primary key for each row to be
inserted into the target. Please note that
EMPLOYEE_ID
will not be the primary
key in the table.
•
PM_CURRENT_FLAG
: The wizard loads
1
for each new record inserted into the
table and marks all history records as
0
; this will allow us to differentiate between
current and historical records.
The Informatica PowerCenter SCD2 mapping uses the
LKP_GetData
lookup transform-
ation to look up the data in the target table and uses the
EXP_DetectChanges
expres-
sion transformation to compare the data with the source data. Based on the comparison,
the expression transformation marks a record as
NewFlag
or
ChangedFlag
. The map-
ping is divided into three flows: