Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > External Data Mapping > Joining Tables and Fields >

Guidelines for Customer Hierarchies and Joins

---

Each join has an optional customer hierarchy field. This field only needs to be set in certain circumstances. Use the following guidelines for setting the Customer Hierarchy field on a join:

Only use the Customer Hierarchy field when you create joins to multiple hierarchies. You would create two joins on the same table and specify which customer hierarchy to use for each one.
Do not associate a customer hierarchy with any start point join that you created for data retrieval of an attribute family. This returns the following error in the MktgSrvr log file:

No STARTPOINT specified on TABLE XXXXX

If you specify a customer hierarchy for a join, that join is restricted to that hierarchy. For example, if you specify customer hierarchy X for join A, join A will not be considered when the Marketing server evaluates the available joins to process customer hierarchy Y.

Bookshelf Home | Contents | Index | Search | PDF