Map Profile Tables for Audience Level wizard

Use the Map Profile Tables for Audience Level wizard to map profile and dimension tables for your interactive channel.

The first screen of the Map Profile Tables for Audience level wizard displays a list of tables you can map, edit, or unmap.

To map a dimension table joined to the profile table, click Map a new Dimension Table. You can only map dimension tables after you have defined a profile table for the audience level.

To edit a table mapping, select the table you want to edit and click Edit Mapping.

To unmap a table, select the table you want to unmap and click Unmap.

Select a table to map
Field	Description
Select a table to map	This is a list of all the tables in the data source 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 should map name for name.
Load this data in to memory when a visit session starts	Select this checkbox to load the record 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. This can improve the overall performance of a runtime session by having the performance impact of reading a database at the start of a runtime session, so all subsequent data requests during the runtime session are faster. You can reload data from tables 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.
IBM® Table Name	The name of the table as it appears 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 IBM® table name must also be unique within the table mapping, per audience level, per interactive channel.
Table details	The Table details field displays the Field Name as it appears in the real data source, the IBM® Field Name as it appears in the Interactive flowcharts, the field Type, and whether or not this 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 should 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 checkbox for the fields upon which you want to join the dimension table to the base table.

If you are mapping a profile table, click Validate mapping.

If you are mapping a reference table, click Map Dimension to Base.

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.

Validate Mapping

When you validate the mapping of a table, the design environment examines all interactive flowcharts, campaigns, and learning configurations associated with this interactive channel to ensure that your changes do not break any part of your interaction configuration. If, for example, you remove a field required by an interactive flowchart, the design environment displays a list of the affected flowcharts that must be revised before you deploy to a runtime environment.

To validate mapping, Interact uses your test run Interact server. Your test run runtime server must be running for Check Syntax to function.

If you are editing a profile table mapping, and the table or field names have changed, Interact unmaps all dimension tables associated with the profile table.

You must click Complete this Change to finish the table mapping.

When you add or edit a dimension table, make sure the schema matches the profile table schema.