The XRef structure helps you to cross-reference entities such as customers, addresses, products, and product categories. It ensures accurate and consistent data mapping across systems. This structure supports seamless data integration, enables relationships between data entities, and enhances visibility from the data model to applications such as Campaign+, Metrics, 360 Profile, and Interactive Queries.
The following are the XRef entities:
- Customer: Links customer profiles to associated addresses to ensure accurate mapping. It acts as a child table.
- Address: Stores and cross-references detailed address information with customer profiles for consistency. It acts as a child reference table.
- Product Category: Groups products into categories and links them through XRef for streamlined inventory and sales analysis. It acts as a dimension table.
- XRef Mapping: Enables mapping and cross-referencing of data between customers, addresses, and product categories. It supports smooth data integration and synchronization across applications.
Use cases¶
The following are the use cases:
- Linking customer profiles with addresses: Ensures accurate association of each customer with their respective address data.
- Associating products with categories: Enables clear categorization of products for better inventory management and sales tracking.
- Maintaining data consistency across systems: Provides reliable synchronization of customer, address, and product category information.
- Enhancing data integration across entities: Supports smooth integration of customer, address, and product category records into applications such as Campaign+, Metrics, and 360 Profile.