Map Profile Tables for Audience Level wizard
Use the Map Profile Tables for the 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 map dimension tables only after you define a profile table for the audience level.
*
*
This 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.
IBM® Table Name
The Table details field displays the field name as it is displayed in the real data source, the IBM® Field Name as it is displayed in the Interactive flowcharts, the field Type, and whether this is a Audience Key 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.
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 that are 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 that is 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 are changed, Interact unmaps all dimension tables that are 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 that the schema matches the profile table schema.