Logical Data Model
Good Logical data model in data warehouse implementation is very important. Logical data model has to be detailed (though some might not agree) as it represents the entire business in one shot and shows relationship between business entities. Logical Model should have following things to make it detailed and self explanatory.
- All entities to be included in data warehouse
- All possible attributes of each entity
- Primary keys of each entity ( Natural Keys as well as Surrogate Keys )
- Relationships between each every entity
e.g.
Logical Data Model of Call Center Data warehouse.
Datawarehouse Logical Data Model
Characteristics of Data Warehouse Logical Data Model
- It has all the entities which will be used in data warehouse
- It shows all possible attributes of all entities
- It depicts the relationships between all entities
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts: