Creating Table Instances from Table Descriptors and Simultaneously Mapping Them

You can create a Table instance in the current Work Area corresponding to each Table Descriptor and map each pair. The system bases the Table instance on the same Table definition the Table Descriptor is based on, and automatically maps the Table Descriptor to the new Table instance.

You can use this method to create multiple Table instances at the same time from Table Descriptors located in a single Load Set, Program, Data Mart, Business Area, Report Set or Workflow. In Report Sets and Workflows this option is available only at the Report Set and Workflow level, not from individual Program instances in the Report Set or Workflow.

Note:

Table instances are created with the default settings for all attributes, including Process Type (which is Staging with Audit). You can go to the Table instances and update them as necessary.

To create a Table instance from one or more existing Table Descriptors in a single Load Set, Program, Data Mart, or Business Area, do the following:

1. In the object's Properties screen, select Table Instances from Existing Table Descriptors from the Actions drop-down list and click Go.

   The Create Table Instances from Table Descriptors screen opens, displaying all the unmapped Table Descriptors.

   Note:

   If you have created the object inside a Workflow, then use the Actions drop-down list job Table Instances from Existing Tables Descriptors from the Workflow's Properties screen. This job is not available in the object's Properties screen.

2. Select the Table Descriptors for which you want to create a Table instance by clicking the box in the Select column.
3. Click Create Table Instance. The system displays a message asking if you want to create the Table instance.
4. Click Yes.

   The system returns you to the Create Table Instances from Table Descriptors screen. To return to the Program's Properties screen, click Return. Check that the mappings are complete.