Conceptual Data Model is the first step in Data Warehouse design. In conceptual data model, very high level relationships between dimension and fact table is depicted. Conceptual data model not necessarily includes keys, attributes of tables. Conceptual data model gives a very high level idea of proposed Data Warehouse design including possible fact and dimension table. Conceptual data model is the stepping stone to design logical data model of Data Warehouse.
e.g.
Conceptual data model of call center Data Warehouse.
Characteristics of Data Warehouse Conceptual Data Model
- It shows only high level relationship between tables.
- It does not show primary key or column names
- It is the stepping stone of Logical Data Model
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts:
{ 1 trackback }