Creating and managing the model

This section describes how to create, import and manage the model.

The model serves as the basis for data warehouse generation in Compose. There are three way of creating the model: Use Compose to derive a tentative model by reverse engineering the source database(s) (a process also known as "discovering"); Import a model created in ERwin or create the model manually in Compose.

In this section:

• Reserved column names
• Generating the model
• Model limitations
• Validating the model
• Displaying the model
• Managing the model
• Creating expressions
• Opening the expression builder
• Defining reusable transformations