Set loading 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 > Load.
  3. Set the following load options as needed:
    Insert Method

    Select whether you want DWD to verify that rows do not already exist.

    Update Method

    Select whether you want DWD to update all rows, only modified rows, or not at all.

    Load Performance

    Select whether you want DWD to prepare the table load by creating a temporary table.

    Internal status columns

    Select from the following. You may select more than one (or all) options.

    • Use Session handling

    • Track inserted and updated rows

    • Status Flag on rows

    • Valid between date interval

  4. Click Apply and OK to set the options.