Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 19: Managing WarehouseArchitect Models

Importing an ERwin model into a WAM

Importing an ERwin model into a WAM

Objects importedYou can import a model built with ERwin into a WAM.

The following objects are imported directly:

Annotation

Business rule

Column

Description

Domain

External column

External database

External table

Index

Key

PowerBuilder extended attribute

Reference

Referential integrity constraint

Table

Tablespace

Target database

Text

In addition, the import process translates ERwin objects into WAM objects as follows:

Object in an Erwin model	Imported object in a WAM
Fact	Fact table or table*
Dimension	Dimension table or table*
Outrigger	Dimension table or table*
Stored display and subject area	Submodel
Relationship and subtype relationship	Reference
Valid value	Check parameter
Segment	Storage

* Imported as a table if object was in automatic mode in ERwin.

You can retrieve the original fact and dimension tables by selecting Retrieve Multidimensional objects in the WAM menu.

Objects not importedYou cannot import User-Defined Properties, Rules, ERwin triggers, ERwin reports, or ER1 files. If you are using ERwin/SQL, generate a database from your ER1 file and then reverse engineer that database into a WAM.

• To import an ERwin model:
  1. Select File-->Import.

     A standard file selection dialog box displays.

  2. Select a file with the ERX extension.

  3. Click OK.

     A message box lists all imported objects.

  4. Click OK.

ERwin external databasesWhen you import external databases, they are not displayed in the workspace. You can make them visible by selecting the Display checkbox in the List of External Tables.