Using Temporary Staging Tables

1. Open the collaboration you want to edit.

2. Right–click a source table, and select Properties.

3. Enter a valid table name for the Staging Table Name property.

   Ensure that the source and staging table structures are the same, including column names and data types. If the staging table structure does not match the corresponding source table, the collaboration will fail with an error message.

4. Select or deselect the Drop Staging Table property to specify whether or not to drop the temporary staging table after the ETL process completes.

5. Select or deselect the Truncate Staging Table property to specify whether or not to truncate the temporary staging table before each run.