Microsoft Business Intelligence

Conceptual Data Model Identifies the highest level of relationship between important entities of Data Model. It contains only important enti...

It is a dimension which is derived from fact table. DD doesn’t have separate dimension table. It is mostly used when we planned use transact...

Preparing ER Data Model ER à split into discrete business process Model Each Process separately Select Many to many relationsh...

It is integral companion to the fact table It contain descriptive information of the business Each dimension is defined by its single prim...

Conformed dimension are the bus architecture linking different data mart It is a dimensional model with common dimension linking to differe...

It is a primary table of a dimension model It contains numerical information of the business It contains aggregate values of duplicating r...