How to reverse engineer your relational data model to a logical data model
Reverse engineering tables to entities supports the bottom-up approach to data modeling.
Getting ready
Import all your source data models as in the previous recipe. Ensure you have saved your model and synchronized with Subversion.
How to do it...
1. Open the relational model, and click on the Engineer to Logical Model icon or select Design | Engineer to Logical Model:
2. Select the tables you are interested in reverse engineering, and click on Engineer:
3. Validate whether the tables have been reverse engineered:
How it works...
Reverse engineering your tables converts them into entities. These can be used within your data model to build your semantic definition, and support a bottom-up approach to modeling. These new entities should be renamed to conform to your naming standards for entities. Once imported, you will need to classify the entities as facts or dimensions. Review the attributes, keep the required attributes...
