Append the NOLOCK table hint after the table definition

Use the steps below to apply the SQL NOLOCK option after the table definition.

Note: 

This is a global setting that applies to all catalog and datamart objects. When an object has a user-defined After Table Definition code, DWD will override the global setting and use the object level code instead.

  1. In the DWD Designer, navigate to Compile > Compilation Options
  2. Select No locking on tables.
  3. Compile the catalog/datamart objects.