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:
- Open a logical data model in the Data Project
Explorer. You can transform from any package
or diagram in the model.
- Click from the main menu.
- 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.
- On the Source and Target page, complete
the following steps:
- Select a logical data model package or diagram in the Selected Source field.
- Select a project or existing logical or dimensional-logical
data model in the Selected Target field and
click Next.
- 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. |
- On the Common page, specify whether
to generate a log for the transformation, and click Finish. The transformation configuration opens.
- Click Run 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.