Bookshelf Home | Contents | Index | Search | PDF

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

Guidelines for Caching

---

When defining joins, Siebel Marketing provides a Cache check box so that you can indicate if the table should be loaded into memory (cached) or accessed from a hard disk.

Use the following guidelines when deciding if you should cache a join.

Do not load large tables into memory unless the server has sufficient physical RAM.
Do not cache joins if the child table is mapped to the customer hierarchy. When a table is mapped to a hierarchy, the Marketing Server uses Merge functionality to retrieve the data.
If the table is not mapped to a customer hierarchy and the table size is 10,000 rows and smaller, cache the join to reduce extract time.

Bookshelf Home | Contents | Index | Search | PDF