Truncating tables and data marts

Truncate a table or data mart to clear its content before executing an ETL process.

To truncate tables and data marts:

  1. On the DWD Designer, click the Data Warehouse tab.
  2. Right-click a model or a model group, then select Truncate all Tables in Name of Model or Model Group.

    A list of tables in a particular model or model group is displayed.

  3. Click Truncate Tables.
  4. To truncate the entire data mart, right-click the data mart, then select Truncate Entire DataMart....

    A list of tables in a particular data mart is displayed.

  5. Click Truncate all Tables.