Database Reference
In-Depth Information
•
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.
•
Expression
(
EXP_KeyProcessing_InsertChanged
): This is used to in-
crement the primary key by
1
and also increment the version number by
1
for
every changed record.
•
Target
(
EMPLOYEE_SCD2_VERSION_NUMBER
): This is the target table in-
stance that accepts new records into the target table.
•
Target
(
EMPLOYEE_SCD2_VERSION_NUMBER1
): This is the target table in-
stance that accepts changed records into the target table.