Set ETL processing 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 > General
  3. Modify the these options as required:
    Compilation type

    Select whether the object can be compiled in the Microsoft SQL Server as a database table or view.

    Refresh or Append

    Choose whether DWD should refresh all data in the table or append new rows.

    Transformation

    Choose the type of transformation.

    To apply user defined code, see the instructions in Using User Defined Code for Processing.

  4. Click Apply > OK to set the options.