Set transformation options

  1. On the Data Source tab, expand the tree view to locate the object.
  2. Right-click the source object and select Detailed Properties > Processing Options > Transformation.
  3. Set the these transformation options as needed:
    Duplicates
    You can select whether DWD allows or removes duplicates.
    Note: The default setting is Allow Duplicates.
    Remove/Recreate Indexes
    You can select Yes to remove indexes before ETL and then recreate them after ETL.
    Note: The default setting is Yes.
    Dimension Keys
    You can select whether DWD adds a dimension key to substitute for the natural keys.
    Note: This only available for Dimension Tables. When creating new dimension tables, the selected default setting is Use Dimension Keys.
    Fact Row Identifier
    You can select whether DWD uses a Fact Row Identifier to add a surrogate key that identifies each fact table.
    Note: This is only available for Fact Tables. When creating new fact tables, the default setting is Use Fact Table Identifier.
    Slowly Changing Dimensions
    You can select whether to overwrite or manage slowly changing dimensions.
    Note: This only available for Dimension Tables. When creating new dimension tables, the default setting is Overwrite dimension properties.
    Managing Exceptions

    You can select whether DWD creates an exception table to store rows that did not transform.

    Note: This available for Dimension and Fact Tables. If enabled, the _ExceptionObjectID_ internal column is added to the Dimension Table. The _ExceptionObjectID_ internal column stores the ObjectID of the executed Fact Table object that triggered the creation of the Dimension Exception Record. When creating new dimension tables, the default setting is Support Exception Handling.
  4. Click Apply and OK to set the options.