Using Pre-Created Temporary Staging Tables

You can manage temporary tables by configuring source table properties. When all the source tables in an ETL collaboration are configured with a valid table name for the Staging Table Name property, no create or drop privileges are required for the target environment.

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.