Database Reference
In-Depth Information
When we create a mapping using this option, the wizard create three additional columns
in the target table:
•
PM_PRIMARY_KEY
: The wizard generates the primary key for each row to be
inserted into the target. Note that
EMPLOYEE_ID
will not be the primary key in
the table.
•
PM_BEGIN_DATE
: The wizard loads
SYSTEMDATE
for each
NewFlag
and
ChangeFlag
record inserted into the table.
•
PM_END_DATE
: The wizard loads
SYSTEMDATE
for each updated record inser-
ted into the table, indicating the end date of the record.
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: