Transformation in IDA
1.Transform from Logic model to physical model: Project --- Data Model (Not Data diagrams) -- Select the logic model --- Data (Menu) -- Transform --Physical Model Use the Transform to Physical Data Model wizard to transform a logical data model into a physical data model. Prerequisites: Analyze your logical data model to ensure that it is valid before you transform it. Set logical data model properties that control transformation results. To transform a logical data model into a physical data model: 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. Click Data > Transform > Physical Data Model from the main menu. As an alternative, you can click the Transform to Physical Data Model toolbar button on the main toolbar. On the first 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. Complete the remaining steps of the wizard.