You can map a new dimension table based on an additional table:
1.
2.
3. The source fields in the table you select are mapped automatically to new table fields in the base dimension table you are creating. To change the default selections, select fields from the Source Table Fields list or the New Table Fields List, and use the Add, Remove, Up 1, and Down 1 buttons, until the table is mapped as required, then click Next.
a.
b. To change a field name, select the mapping in the New Table Fields list, and edit the text in the IBM Unica Field Name field, then click Next.
6.
7.
8.
The option Always use inner join will always use an inner join between the base table and this dimension table, returning only audience IDs from the base table that appear in the dimension table. The Always use outer join option will always perform an outer join between the base table and this dimension table (which provides the best results if the dimension table is known not to contain at least one row for every audience ID in the base table). The default setting of auto uses an inner join in the Select and Segment processes and an outer join in output processes (Snapshot, Mail List, and Call List). This typically provides the desired behavior where values in the dimension table are required for selection criteria, but NULLs should be output for missing audience IDs for any dimension table fields that are output.
11. Click Finish.
IBM Unica Campaign
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|