Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide > External Data Mapping > Setting Up Target Group Segment Tables and Joins >
Creating Joins for Target Groups
After completing all tasks in the Mapping the Analytic Adapter Tables to the Marketing Repository Server section, you will need to create joins to support the process of extracting a target group from the source database through the Analytics Server and load the customer list into a campaign. This section contains recommended joins for the tables required to generate a snapshot using a target group segment.
NOTE: The Subject Area in Siebel Analytics is treated as a single logical table name in Siebel Marketing.
To create joins for target group segmentation
- Create the following joins: Create a start point join to each subject area table that you want to use to create segments. For example:
- Create a start point join to each alias of the S_DD_TRGT_GRP table. You mapped these in Step 4. For example:
Join Parent Table Child Table Type Cardinality Table <null> "Account Group" default <null> "Consumers Group" default- Create a table join from the subject area table to one of the aliases of the X_DD_TRGTGRPMBR table. You mapped these in Step 4. For example:
Join Parent Table Child Table Type Cardinality Table "Subject Area" "Target Group Accounts" Equal N:N
- Create a field join to the alias of the X_DD_TRGTGRPMBR table for the corresponding customer level. For example:
- Join each alias of the X_DD_TRGTGRPMBR table to each alias of S_DD_TRGT_GRP table. For example:
Join Parent Table Child Table Type Cardinality Table "Target Group Accounts" "Account Group" Equal N:1
- Create field joins, repeating for Consumers or Households. For example:
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide Published: 23 June 2003 |