This is third step for Designing for DWH Design
Physical Data Model is the actual model which will be created in the database to store the data. It is the most detailed data model in Data Warehouse data modeling. It includes
Physical Data Model can be converted to actual SQL DDL statement by using different tools. ERWIN is the famous tool to do this.
Physical Data Model is the actual model which will be created in the database to store the data. It is the most detailed data model in Data Warehouse data modeling. It includes
- Tables names
- All column names of the table along with data type and size
- Primary keys, Foreign Keys of a table
- Constraints
Physical Data Model can be converted to actual SQL DDL statement by using different tools. ERWIN is the famous tool to do this.
No comments:
Post a Comment