Database Reference
In-Depth Information
ment. Select
Type 2 Dimension - keep a full history of the changes in the tar-
get
, as we are implementing SCD2 using a version number. Click on
Next
.
2. The next screen will ask you to select the source. Select a source from the drop-
down list. We are using
EMP_FILE.txt
as the source file for our reference.
Also, specify the name of the target you wish to create. We will name the target
EMPLOYEE_SCD2_VERSION_NUMBER
in this topic for our reference. Then,
click on
Next
.