Chapter 6 Working with PDMs
When you open a version 6 data warehouse model into the current version of PowerDesigner, the links to external sources are preserved thanks to a mapping mechanism.
For more information on object mapping, see section Mapping Objects in a PDM.
| Version 6 | Current version | Details |
|---|---|---|
| External database | Physical Data Model opened in the current workspace | Each external database becomes a new PDM with the same name and the same DBMS family. A message appears if the DBMS cannot be found |
| External table | Table in the new Physical Data Model opened in the current workspace | The external tables in the external database become regular tables in the new PDM. A shortcut is created for each external table in the imported model to illustrate the mapping |
| External column | Column in the tables of the new Physical Data Model opened in the current workspace | The external columns become columns in the tables of the new PDM |
The concept of external database in PowerDesigner version 6 becomes a data source: when you import a data warehouse model with one or several external databases, the model is imported and the external databases are converted into physical models. These models are automatically declared as data sources of the imported model, and the tables of the model are mapped with tables in the data source. Shortcuts of the mapped tables appear in the imported model diagram.
For more information on data sources, see section Defining data sources in a PDM.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |