Physical Data Model

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

1. Tables names
2. All column names of the table along with data type and size
3. Primary keys, Foreign Keys of a table
4. Constraints

e.g.

Physical Data Model of Call Center Data warehouse.

Physical Data Model can be converted to actual SQL DDL statement by using different tools. ERWIN is the famous tool to do this.

Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!

Related posts:

1. Conceptual Data Model
2. Logical Data Model
3. Semantic Data Model

Tagged as: Data Warehousing Concepts, Physical Data Model