13.4.2.4.1.1.1 SCD (Slowly Changing Dimensions)

Note:

If you have selected the Retire SCD, you must load snapshot data for master tables and execute SCD process with additional parameters.

To configure this widget, complete the following steps:

1. On the Process Flow page, from the LHS menu, expand Widget and drag and drop this widget on to the canvas.
2. Double-click the widget on the canvas. The configuration window is displayed with the Activity tab selected.
3. Under Dynamic Parameters, configure the settings described in the following table.
4. Click the tick mark icon to save your changes. To close the configuration window, click anywhere outside the window on the canvas.

Table 13-1 Dynamic Parameters for SCD Description

Property	Description
Datastore Name	Refers to the name of the Information Domain. By default, the Information Domain to which you are connected is selected.
Name	Select the name of the required dimension table.
Dimension Retire	Select the dimension that you want to overwrite.
Execution Venue	Enter name of the Execution Venue. This field is case-sensitive and must be unique. For example, logical name “R_DF” is not allowed if a name “R_DF” exists. Ensure that there are no special characters such as `, {,},”, ‘, ~, <,>, /, \, and multiple spaces.
Effective Date	Enter the start date from when the data is valid.