Chapter 6 Working with PDMs

Defining a relational to relational mapping

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:

The relational to relational mapping implies:

• The creation of data sources to define where the data comes from
• The mapping of each table in the data warehouse model with tables in the source model

For more information on creating a data source, see section Creating a data source in a PDM.

Copyright (C) 2005. Sybase Inc. All rights reserved.