To map a base record table to an existing database table

You can map a new base record table to an existing database table:

When editing a flowchart, either through the Admin menu, or a Select process, as described in Working with user tables while editing a flowchart .

Through the Campaign Settings page, as described in Working with user tables from the Campaign Settings page.

You map a new base record table to make data accessible to processes in flowcharts.

Begin from the New Table Definition - Select the table type window.

When you access the table mapping wizard from a Select process, the Dimension Table and General Table options are not listed.

If necessary, select Base Record Table, then click Next.

Select Map to Existing Table in Selected Database, select the data source name, then click Next.

Select the table you want to map from the Source Table list.

The tables are listed in alphabetical order by <owner>.<table_name>. If you do not see a table you expect, check whether the data source is configured to filter specific table entries.

The source fields in the table you select are mapped automatically to new table fields in the base record table you are creating. To change the automatic mappings, select fields from the Source Table Fields list or the New Table Fields List, and use the Add, Remove, Up 1, an Down 1 buttons, until the table is mapped as required.

You can click on the Field Name column in the New Table Fields section to automatically sort column names alphabetically in ascending (or descending) order.

Click Next.

Optionally, you can change the name which Campaign will use for the base record table and its fields to a more user-friendly value.

To change the table name, edit the name in the IBM® Campaign Table Name field.

To change a field name, select the field name in the New Table Fields list, and edit the text in the IBM® Campaign Field Name field.

Click Next.

Select an Audience Level from the drop-down list. The Audience Fields list is automatically populated with the fields required to define the selected audience level. You must match one or more fields in the new base table that correspond to each required key.

If the selected audience level is normalized (if each unique audience ID appears no more than once in the current base table), check This audience level is normalized in this table.

Setting this option correctly is important for correct configuration of options in an Audience process. If you don't know the correct setting, leave this option unchecked.

10.

Click Next.

11.

Optionally, in the Specify Additional audience levels screen, you can specify one or more additional audience levels contained in the base record table. Adding additional audience levels allows users to use this table as a "switching table" to translate from one audience level to another using the Audience process in a flowchart.

Click Add.

The Audience Level and ID Fields window opens.

Select an Audience Level Name.

For each Audience Field, match appropriate field(s) from the base table to the corresponding key(s) in the audience level.

If the selected audience level is normalized (that is, each unique audience ID appears at most once in the current base table), check This audience level is normalized in this table.

Click OK.

Repeat steps a through f for each audience level you want to add for the base table, then click Next.

12.

If dimension tables exist in the current table catalog, the Specify Relationship to Dimension Tables window opens:

Check the box to the left of any dimension table that is related to the base record table you are creating.

For each related dimension table, in the New Table's Key Fields(s) To Use list, select a field from the base table to match each listed key in the Dimension Table's Key Field(s) list, then click Next.

13.

You can choose to pre-compute the distinct values and frequency counts for specific fields, or allow users to perform real-time profiling of data in the base record table.

14.

Click Finish.

You have created the base record table based on an existing database table. The new base table is part of the current table catalog, which you can manage through the table manager.