To map a dimension table

You can map a new dimension table based on an additional table:

When editing a flowchart, through the Admin menu, 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 dimension table to make data that augments data in a base table, such as demographics based on postal codes, accessible to processes in flowcharts.

Dimension tables must be mapped to a database table and must be related to one or more base tables that are mapped to tables in the same IBM® data source (that is, the same database). In defining the dimension table, you can specify the specific join conditions between the base and dimension tables.

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

You cannot map a dimension table from a Select process.

Select Dimension Table, then click Next.

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

The source fields in the table you select are mapped automatically to new table fields in the base dimension table you are creating. To change the default selections, select fields from the Source Table Fields list or the New Table Fields List, and use the Add, Remove, Up 1, and Down 1 buttons, until the table is mapped as required, then click Next.

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.

(Optional) Change the name Campaign will use for the dimension table and its fields.

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

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

Specify the dimension table's key(s), and how the table will be joined to base record tables.

Select one or more keys in the Key Field(s) list.

Check Key Field(s) are Normalized in This Table, if this is the case.

Select the Table Join Method, then click Next.

The option Always use inner join will always use an inner join between the base table and this dimension table, returning only audience IDs from the base table that appear in the dimension table. The Always use outer join option will always perform an outer join between the base table and this dimension table (which provides the best results if the dimension table is known not to contain at least one row for every audience ID in the base table). The default setting of auto uses an inner join in the Select and Segment processes and an outer join in output processes (Snapshot, Mail List, and Call List). This typically provides the desired behavior where values in the dimension table are required for selection criteria, but NULLs should be output for missing audience IDs for any dimension table fields that are output.

If base record tables exist, the Specify Relationship to Base Tables screen opens. Check the box to the left of any base record table that is related to the dimension table you are creating Specify the join fields, then click Next.

10.

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.

11.

Click Finish.

You have created the dimension table.