Databases Reference
In-Depth Information
In this example, three additional columns will be specified for CUSTOMER_SCD:
two change-tracking columns (VALID_FROM_DTTM and VALID_TO_DTTM) and
a column for generated keys (CUSTOMER_GEN_KEY).
CUSTOMER_TRANS and CUSTOMER_SCD have been registered in a current
metadata repository.
You have selected a default SAS application server for SAS Data Integration
Studio, as described in “Selecting a Default SAS Application Server” on page 96.
This server can access all tables that are used in the job.
The main metadata repository is under change-management control. For details
about change management, see “Working with Change Management” on page 113.
It is assumed that you have started SAS Data Integration Studio and have opened
the appropriate metadata profile.
The first task is to check out any existing metadata that must be updated for the
current job.
Check Out Existing Metadata That Must Be Updated
You do not have to check out the metadata for a table in order to add it as a source or
a target in a job. However, the metadata for the CUSTOMER_SCD table must be
checked out because (a) we assume that the metadata for this table was created and
checked in earlier, and (b) the metadata for the table must be updated for the current
job.
Follow these steps to check out existing metadata:
1
On the SAS Data Integration Studio desktop, select the
Inventory
tab.
2
In the Inventory tree, open the
Tables
folder.
3
Select the table that must be updated for the current job: CUSTOMER_SCD.
4
Select
Project
Check Out
from the menu bar. The metadata for this table will
be checked out and will appear in the Project tree.
The next task is to create and populate the job.
Create and Populate the Job
Follow these steps to populate the job
Load the Customer Dimension
:
1
In SAS Data Integration Studio, in the
Shortcuts
pane, click
Process Designer
to start the New Job Wizard.
2
In the
New Job Wizard
, type the job name
Load the Organization Dimension
and click
Finish
. An empty Process Designer window is displayed.
3
In the tree view, click the
Process Library
tab, then expand the
Data
Transforms
folder.
4
In the
Data Transforms
folder, click and drag
SCD Type 2 Loader
into the
Process Designer window. Release the mouse button to display the SCD Type 2
Loader transformation template in the Process Designer window for the new job.
The template displays with drop zones for a source and a target.
5
In the tree view, select the
Inventory
tab.
6
In the Inventory tree, open the
Tables
folder.
7
In the
Tables
folder, click and drag the
CUSTOMER_TRANS
table into the source
drop area of the SCD Type 2 Loader.
8
In the tree view, click the
Project
tab.
Search WWH ::
Custom Search