Platform Deployment Guide › Data Warehouse › Advanced Configuration › Reconfigure a Data Warehousing Job › Job Configuration Parameters › Truncate_On_Next_Run

Truncate_On_Next_Run

Use this parameter to purge all data from the data warehouse.

Syntax

If this parameter is set to 1, all data is purged from the data warehouse.

If this parameter is set to 0 or omitted, all data is retained in the data warehouse.

SQL Server

@Truncate_On_Next_Run=1 or 0

Oracle

Truncate_On_Next_Run=>1 or 0