Microsoft Business Intelligence

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...

All information about the data warehouse environment It is not actual data It is similar to databank It is similar to Encyclopedia

Extraction is an initial step to bring the needed data to staging area for further process Transformation process involves converts the dat...