Generating the physical model

Introduction

There are two ways to generate a physical model:

· by running the "MDACs/SQL Designer/Generate physical model" command available in the context menu which appears when you right-click

· by clicking on the button, available in the "SQL" tab of the auxiliary window on a package

Updating a physical model

A physical model can be updated if the logical model to which it is linked has been modified. For this, three solutions are available:

· running the "MDACs/SQL Designer/Generate physical model" command on the physical model, available in the context menu which appears when you right-click. A dialog box informs you that the physical model will be updated. Simply confirm by clicking "OK" to start the update.

· clicking on the button in the "SQL" tab of the auxiliary window for a physical model. Simply click on this button to update the physical model.

Avoiding the update of the physical model

If you want a part of the physical model not to be updated, for example, a table or a column added manually, you can annotate this element {sqlDoNotUpdate}. The "Do not update" tickbox in the "SQL" tab of the auxiliary window can be used to add this tagged value.

Note: If a table is annotated {sqlDoNotUpdate}, neither the table nor its contents will be updated.