Transforming a logical data model into a physical data model

Use the Transform to Physical Data Model wizard to transform a logical data model into a physical data model.
Before you begin
About this task

To transform a logical data model into a physical data model:

  1. Select a logical data model or a logical data model object in the Data Project Explorer. You can transform from an .ldm file, a package, or an entity.
  2. Click Data > Transform > Physical Data Model from the main menu. As an alternative, you can click the Transform to Physical Data Model toolbar button Transform to Physical Data Model toolbar button icon on the main toolbar.
  3. If the Check Model page is displayed, select the appropriate options:
    • If you do not want to analyze the logical data model, clear the Analyze logical model before transformation check box.
    • If you want to analyze the logical data model, perform the following steps:
      1. Ensure that th the Analyze logical model before transformation check box is selected and click Next.
      2. Review the logical data model analysis results on the Check Model Results page.
      3. If problems are found in the model and you want to fix them, click Cancel to close the wizard. The details of the model analysis problems are shown in the Problems view. Double-clicking an entry in the Problems view selects the appropriate model elements in the Data Project Explorer.
  4. On the Target Physical Model page of the wizard, specify whether to create a new physical data model or update an existing physical data model. If you select to create a new physical data model, you can select a template to use on the next pages of the wizard. You can use a provided template or you can use a template that was exported from an existing physical data model. The resulting physical data model is a copy of the template with the addition of elements that are generated by the transformation.
    Tip: The traceability option creates a dependency between logical data model objects and physical data model objects so that you can trace the lineage of the objects. This dependency, when used with the impact analysis feature, helps you to determine what objects are impacted by changes to other objects. If you are updating an existing physical data model, you also can use traceability to match certain types of data model objects that are renamed during transformation.
  5. Complete the remaining steps of the wizard.
Results
If you selected to create a new physical data model, the physical data model is created and displayed in the Data Models folder of the data design project that you specified.

If you selected to update an existing physical data model, the compare editor opens so that you can merge changes. If you are using traceability, all renamed table, column, entity, and attribute pairs are resolved automatically. To use traceability, the Use transformation traceability in determining renamed tables, columns, entities, and attributes check box must be selected on the Data Object Compare preference page, and the traceability option must be used consistently during transformations.

If errors occur during the transformation, they are logged as entries in the Error Log view. A stack trace is attached to an error log entry, if applicable. To see the details of an error log entry, including its stack trace, double-click the entry.


Feedback