Bookshelf Home | Contents | Index | PDF |
Oracle® Marketing Segmentation Guide > Configuring Marketing Module Metadata > Setting Up Marketing Segmentation Metadata > Setting Up Conforming Dimension LinksConforming dimensions can be used when a star might include a dimension with the target-level ID. A conforming dimension links a fact that contains target-level IDs to a fact that does not contain target-level IDs by navigating along a dimension that is shared by both fact tables. A conforming dimension path must start from the primary segmentation catalog. Conforming dimensions can be chained. For example, the data warehouse might have an Offer-Product Star schema. To segment individuals who are offered a particular product, you must set up the following two conforming dimension links:
The marketing module reads these links and identifies the campaigns that included the products that were offered and then identifies all the contacts that were targeted in those campaigns. To setup conforming dimension links
To duplicate a conforming dimension link
Conforming Dimensions ExampleA bank might track service requests at bank-account level and not the contact level. In this example, there is an intersection fact that identifies the contacts that belong to each account (Contact-Account) and another fact table that tracks the service histories of the service requests on the accounts. The bank needs to perform the following mappings: |
Oracle® Marketing Segmentation Guide | Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |