Mapping the translation table
Map a translation table to make IBM Digital Analytics segments accessible in Unica Campaign. The table mapping identifies essential information such as the data source, table name and fields, and audience levels.
Before you begin
About this task
Mapping a new base record table makes data accessible to processes in flowcharts. The instructions below explain how to map a new base record table for global use. You can also map a new base record table when you edit a flowchart, by using Admin > Tables.
Procedure
-
Select Settings > Unica Campaign
Settings > Manage table mappings.
For details, see Mapping and unmapping user tables.
-
Optional: Save the mapping information in a table catalog for reuse. To make the
information available for use in all flowcharts, store it in the default catalog (default.cat).
Unica Campaign users can load the saved
catalog to get the mappings.
For details, see Table catalog administration.
-
If there is a change to the physical table (for example, if columns are added or deleted),
you must remap the table. If you do not remap the table, flowcharts that use IBM Digital Analytics segments will return an
error at run time indicating that the table schema has changed.
Important: When you map or remap a table, the Unica Campaign Table name that is assigned in the Table Definition wizard must exactly match the TranslationTableName that is defined in the Unica Campaign configuration settings. If you do not edit the table name when using the Table Definition wizard, the names will match. See Campaign | partitions | partition[n] | Coremetrics).