Chapter 12 Creating Mappings
Data warehousing requires to extract, transform, and load data from operational systems to a data warehouse database. You can map PDM objects to create a relational to relational mapping between operational and data warehouse data.
Operational and data warehouse data can be designed in physical data models.
This kind of mapping is used to clearly identify the data sources i.e. the operational databases, of the data warehouse database.
Moreover, once this mapping is defined, it can be used to generate extraction scripts to populate a data warehouse with operational data.
The following table lists object mapping in a relational to relational mapping:
| Operational object | Data warehouse object |
|---|---|
| Table | Table (Fact or Dimension type) |
| Column | Column |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |