Accessing a dimension table from Unica Campaign in your interactive strategy

To access a dimension table from Unica Campaign in your interactive strategy, you map the dimension table joined to the profile table to the interactive channel. Use the Summary tab of an interactive channel to map the dimension table. You use the Map tables for audience level wizard to complete this task.

Before you begin

You must map the profile tables for the interactive channel before you can map the dimension tables.

Before you begin this task, you must have this information for the Map tables for audience level wizard:
  1. Name of the dimension table you want to map.
  2. Name of the table to which you are mapping the dimension table.
  3. Fields in the base table to which you are mapping the dimension table key fields.
  4. Join type for the tables. Either auto-selected, inner join, or outer join.

About this task

The Map tables for audience level wizard uses the data source that is defined in the Campaign > partitions > partitionN > Interact > flowchart > datasource property.

All interactive channels must reference the same data source.

Procedure

  1. In the Interactive channel summary window, on the Summary tab, click the name of the profile table under Mapped profile table.

    The Map tables for audience level wizard is displayed.

  2. Click Map a new dimension table.
  3. Complete the Map tables for audience level wizard.