Chapter 12 Creating Mappings

Physical Data Model mappings

In a Physical Data Model (PDM), you can link physical and multidimensional objects for the following purposes:

• Relational to relational mapping between physical objects to generate extraction scripts to populate a data warehouse with operational data.
• Relational to multidimensional mapping between physical and multidimensional objects to generate text files containing cube data to fill the OLAP database.

You create a mapping between PDM objects to express a simple correspondence between objects or to setup a structure for data movement and transformation. Data comes from a data source and is loaded in another database.

In PowerDesigner, the data source and the destination database can be designed in physical data models.

Data is taken from a database and sent to another database. The transfer can be from operational to data warehouse or OLAP databases, or from data warehouse to OLAP databases. Operational and data warehouse data are designed in physical diagrams and OLAP data are designed in multidimensional diagrams.

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