Creating Temp Tables

To create a temp table, follow these steps:

1. Create a database view that contains the SQL definition for the temp table. Name the view with a prefix that contains VW and the name of the scenario group in which the view is used (that is, BC, TC, AML, FR, or INSURANCE). The rest of the name should provide a meaningful description of the table’s purpose (for example, VWBSM_RCNT_MFUND_TRDS).
2. Create a table that contains the records from the view. The table name should be the same as the view with the extension _TMP (for example, VWBSM_RCNT_MFUND_TRDS_TMP).
3. Create a wrapper dataset for the temp table.
4. Document the SQL scripts to create the view, and then refresh the temp table.