Databases Reference
In-Depth Information
3
Click the right arrow to move the selected columns into the right pane. The
Detect Changes
tab will look similar to the following display.
Display 12.11
Detect Changes Tab
4
Click
Apply
to save your changes.
You have now configured the process flow shown in Display 12.5 on page 206. The
next step is to run the job.
Run the Job and View the Results
The slowly changing dimension job is now ready to run. In the Process Designer,
right-click and select
Save
. Then right-click and select
Submit
.
If job execution terminates due to errors, click the
Log
tab, locate the error, resolve
the error in the Process Editor, and submit the job again.
To view the results of the job, click the
Process Editor
tab, right-click
ORGANIZATION_DIM
, and select
View Data
. The View Data window shows typical
results for initial loads of new slowly changing dimension tables, including the following:
sequential generated key numbers for CUSTOMER_GEN_KEY
the current date and time in VALID_FROM_DTTM
fictitious place-holding date/time values in VALID_TO_DTTM
Search WWH ::
Custom Search