Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Conformed Dimensions >
Limiting the Entities Cross-Referenced in IA_XRF_ENTITIES
By default, the cross-reference entities load mappings load every entity from the following four dimension tables: - Customers dimension:
IA_CUSTOMERS
- Suppliers dimension:
IA_SUPPLIERS
- Employees dimension:
IA_EMPLOYEES
- Web Visitors dimension:
IA_WEB_VISITORS
To limit which entities are loaded into the cross-reference table, edit the SQL statement in the Source Qualifier of the appropriate PLP cross-reference entities load mapping. To limit the entities loaded into IA_XRF_ENTITIES
- In PowerCenter Designer, open the Configuration for Post Load Processing folder.
- Open the appropriate PLP cross-reference entities load mapping and edit the Source Qualifier for the type of record you want to limit on the cross-reference entities table:
- Customers. Open the
M_PLP_XRF_ENTITIES_CUSTOMERS_LOAD mapping, and edit the SQ_XRF_ENTITIES_CUSTOMERS_LOAD Source Qualifier.
- Suppliers. Open the
M_PLP_XRF_ENTITIES_SUPPLIERS_LOAD mapping, and edit the SQ_XRF_ENTITIES_SUPPLIERS_LOAD Source Qualifier.
- Employees. Open the
M_PLP_XRF_ENTITIES_EMPLOYEES_LOAD mapping, and edit the SQ_XRF_ENTITIES_EMPLOYEES_LOAD Source Qualifier.
- Web visitors. Open the
M_PLP_XRF_ENTITIES_WEB_VISITORS_LOAD mapping, and edit the SQ_XRF_ENTITIES_WEB_VISITORS_LOAD Source Qualifier.
- Edit the SQL statement in the Source Qualifier to select only the desired set of entities.
- Validate and save your changes to the repository.
|