Map tables for audience level wizard

Use the Map tables for audience level wizard to map profile and dimension tables from Unica Campaign to your interactive channel.

Requirements

When you are working with the wizard and you:

  • Validate mapping, Unica Interact uses your test run Unica Interact server. Your test run runtime server must be running for Check Syntax to function.
  • Add or edit a dimension table, the schema must match the profile table schema.

Available tasks

Use the wizard to complete table mapping tasks:
Tasks Flow

Map a new profile table
  1. Click Unmapped for the audience level that you want to map.
  2. Complete the fields for the profile table.
  3. Select Validate mapping to validate the mapping.
  4. Select Complete this change to finish the mapping.

Map a new dimension table
You can map dimension tables only after you define a profile table for the audience level.
  1. Click Map a new dimension table.
  2. Complete the fields for the dimension table.
  3. Select Complete this change to finish the mapping.

You do not validate this mapping.

Edit a table mapping
When you edit a profile table mapping and change the table or field names, Unica Interact unmaps all dimension tables that are associated with the profile table.
  1. Select the table that you want to edit.
  2. Modify the fields for the table.
  3. If you modify a profile table, Select Validate mapping to validate the mapping.
  4. Select Complete this change to save the mapping changes.

Unmap a table
  1. Select the table that you want to unmap.
  2. Click Unmap.
  3. Select Complete this change to save the changes.

Fields used when you select a profile table to map

This table lists and describes the fields that you use when you select a profile table to map:

Table 1. Select a table to map
Field Description

Select a profile table to map

This list is a list of all the tables in the data source that is defined by the Campaign > partitions > partitionN > Interact > flowchart > dataSource property.

If you are mapping the profile table, you must select a table that contains the audience ID defined in the Campaign > partitions > partitionN > AudienceLevels category. Each audience ID column maps name for name.
Load this data in to memory when a visit session starts Select this check box to load the record that is associated with the Audience member into the runtime session when the session starts. If you select this feature for all dimension tables in the interactive channel, all database reads for the selected audience level occur at the start of a runtime session. The process of reading a database at the start of a runtime session so that all subsequent data requests during the runtime session are faster can improve overall runtime performance. You can reload data from tables by using the setAudience method. If you load all data in to memory, while it can improve performance, it also increases the memory requirements for the system.
Unica Interact table name The name of the table as it is displayed in Interactive flowcharts. You can change how the table name displays in interactive flowcharts to make it easier for your flowchart designers to select the correct tables. The name cannot be empty, must begin with a letter, and can contain only alphanumeric characters and underscores. The Unica Interact table name must also be unique within the table mapping, per audience level, per interactive channel.
Table details
The Table details field displays information for the field:
  • The field name as it is displayed in the real data source.
  • The Unica Interact field name as it is displayed in the interactive flowcharts.
  • The field Type.
  • Whether this field is a Audience key field.

If you are mapping a profile table, most of this table is disabled. The fields that match the audience ID fields have Audience key selected. You can define Default values for every field.

If you are mapping a dimension table, the Audience Key column is enabled. Select the Audience key check box for the fields upon which you want to join the dimension table to the base table.

Fields used when you map a dimension table to a base profile table

This table lists and describes the fields that you use when you select a table to map:

Table 2. Map dimension to base
Field Description
The dimension table relates to the following base table Select the table to which you want to join this dimension table.
Matching base table field Select the fields from the base table to which the key fields in the dimension table map.
Join type Select how you want to join the tables. Valid choices are Auto-selected, Inner join, and Outer join.