You can map a new base record table to an existing database table:
When editing a flowchart, either through the Admin menu, or a Select process, as described in Working with user tables while editing a flowchart .
You map a new base record table to make data accessible to processes in flowcharts.
1.
2.
3.
4. The tables are listed in alphabetical order by < owner>.< table_name>. If you do not see a table you expect, check whether the data source is configured to filter specific table entries.The source fields in the table you select are mapped automatically to new table fields in the base record table you are creating. To change the automatic mappings, select fields from the Source Table Fields list or the New Table Fields List, and use the Add, Remove, Up 1, an Down 1 buttons, until the table is mapped as required.You can click on the Field Name column in the New Table Fields section to automatically sort column names alphabetically in ascending (or descending) order.
5.
a.
b. To change a field name, select the field name in the New Table Fields list, and edit the text in the Unica Field Name field.
7.
8. Select an Audience Level from the drop-down list. The Audience Fields list is automatically populated with the fields required to define the selected audience level. You must match one or more fields in the new base table that correspond to each required key.
9. If the selected audience level is normalized (that is, each unique audience ID appears at most once in the current base table), check This audience level is normalized in this table.Setting this option correctly is important for correct configuration of options in an Audience process. If you don't know the correct setting, leave this option unchecked.
10.
11.
a.
b.
c. For each Audience Field, match appropriate field(s) from the base table to the corresponding key(s) in the audience level.
d. If the selected audience level is normalized (that is, each unique audience ID appears at most once in the current base table), check This audience level is normalized in this table.
e.
f.
b. For each related dimension table, in the New Table’s Key Fields(s) To Use list, select a field from the base table to match each listed key in the Dimension Table's Key Field(s) list, then click Next.
14.
IBM Unica Campaign
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|