Limitations

Understand the limitations and solutions when implementing Online cache group policy.

Relationships between MBOs are not supported, unless they are between MBOs generated from the same load operation (also referred to as multiple MBOs from a single load operation or commingled MBOs).
The requirement of propagating the value of the load parameter to an attribute can be bypassed, and is illustrated with this example:
1. SELECT id, empName, empDeptId FROM sampledb.dba.emp (no load parameter)
2. Modify the load definition to be:
```
SELECT   id,  empName,  empDeptId FROM sampledb.dba.emp 
WHERE :fakeLP != null
```
3. Create a new int attribute (fakeAttrib) on the MBO and on the Load Parameters tab and propagate fakeLP to the newly added attribute (fakeAttrib).
  The object query now takes a parameter even though it is not used. In effect, the load operation is used to select the data and the generated object query returns all the rows returned from the load operation.