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 argument to an attribute can be bypassed, and is illustrated with this example:
- SELECT id, empName, empDeptId FROM sampledb.dba.emp
(no load argument)
- Modify the load definition to be:
SELECT id, empName, empDeptId FROM sampledb.dba.emp
WHERE :fakeLP != null
- Create a new int attribute (fakeAttrib) on the MBO and propagate fakeLP to the newly added attribute (fakeAttrib) on the Load Arguments tab.
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.