Database Reference
In-Depth Information
the
PM_BEGIN_DATE
column in the target, marking the start of the record in the
EMPLOYEE_SCD2_DATE_RANGE1
target instance.
•
Expression
(
EXP_CalcToDate
): This uses
SYSTEMDATE
to update the
PM_END_DATE
column in the
EMPLOYEE_SCD2_DATE_RANGE2
target in-
stance in an existing record, indicating that the record is not current anymore.
•
Target
(
EMPLOYEE_SCD2_DATE_RANGE
): This is the target table instance that
accepts new records in the target table.
•
Target
(
EMPLOYEE_SCD2_DATE_RANGE1
): This is the target table instance
that accepts changed records in the target table.
•
Target
(
EMPLOYEE_SCD2_DATE_RANGE2
): This is the target table instance
that allows updates to existing records in the target table.