Transforming logical data models into dimensional-logical data models

To transform a logical data model into a dimensional-logical data model, select and open a logical data model that has dimensional notation enabled, then run a Logical Data Model to Dimensional-Logical Data Model transformation configuration.

Before you begin

  • If you want to generate a snowflake, star, or starflake schema, the source model must contain dimensional notations that specify the facts, dimensions, and other dimensional objects in the model.
  • Analyze your logical data model to ensure that it is valid before you transform it.

About this task

You can create and run a transformation configuration to transform a logical data model into a dimensional-logical data model. This transformation configuration is saved in your workspace and can be reused.

Procedure

To transform a logical data model into a dimensional-logical data model:

  1. Open a logical data model in the Data Project Explorer. You can transform from any package or diagram in the model.
  2. Click File > New > Transformation Configuration from the main menu.
  3. On the Specify a Configuration Name and Transformation page, select Logical Data Model to Dimensional-Logical Data Model from the Data Model Transformations list, enter a name for the transformation, and click Next.
  4. On the Source and Target page, complete the following steps:
    1. Select a logical data model package or diagram in the Selected Source field.
    2. Select a project or existing logical or dimensional-logical data model in the Selected Target field and click Next.
  5. On the Properties page, specify the properties of the transformation configuration:
    Property Description
    Degeneralize and, if dimensional notation exists, denormalize to Use this option to specify whether to denormalize the dimensional model and generate the schemas. If you do not want to generate a hierarchy, select Degeneralize only. To generate a schema, select a schema type.
    Generate Date and Time dimension entities (if applicable) Use this option to specify whether to create Date and Time dimension entities for the resulting dimensional model.
    Generate traceability Use this option to specify whether to trace all of the steps of a business process.
  6. On the Common page, specify whether to generate a log for the transformation, and click Finish. The transformation configuration opens.
  7. Click Run Logical Data Model to Dimensional-Logical Data Model (Logical Data Model to Dimensional-Logical Data Model) from the toolbar.

Results

The dimensional-logical data model is created and displayed in the Data Models folder of your target project. The new dimensional logical data model is named after your logical data model source package or diagram, and has _D at the end of the file name. For example, if your source package or diagram is named Sales, the resulting dimensional-logical data model is named Sales_D.ldm.


Feedback