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

  1. Create the following joins: Create a start point join to each subject area table that you want to use to create segments. For example:

    2. Join
    Parent Table
    Child Table
    Type
    Cardinality
    Table
    <null>
    "[name of the subject area]"
    default
     

  2. Create a start point join to each alias of the S_DD_TRGT_GRP table. You mapped these in Step 4. For example:

    3. Join
    Parent Table
    Child Table
    Type
    Cardinality
    Table
    <null>
    "Account Group"
    default
     
     
    <null>
    "Consumers Group"
    default
     

  3. 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:

    4. Join
    Parent Table
    Child Table
    Type
    Cardinality
    Table
    "Subject Area"
    "Target Group Accounts"
    Equal
    N:N

  4. Join each alias of the X_DD_TRGTGRPMBR table to each alias of S_DD_TRGT_GRP table. For example:

    5. Join
    Parent Table
    Child Table
    Type
    Cardinality
    Table
    "Target Group Accounts"
    "Account Group"
    Equal
    N:1

  5. Repeat Step 3 and Step 4 to create joins for the other levels of your customer hierarchy.

 Siebel Marketing Guide 
 Published: 23 June 2003