Microsoft Business Intelligence

In SQL Server Analysis Services (SSAS), Linked Dimension is a dimension which is existed in other analysis services DB. It may exist in sam...

Conformed dimension is a dimension that has a single meaning or content throught datawarehouse.we can use it accross the fact tables Exam...

Role Playing dimension is a dimension, it can play different roles in a fact table depending on the context. For example: Date dimension ...

A junk dimension is a collection of random transcational codes flags and text attributes that are unrelated to any particular dimension.The ...

Operational Data Store(ODS) Data warehouse ODS is an Online integration of data Typically it wo...

Data warehouse is repository of data, which are collected from many sources like transactional database or old backup data, etc., and then f...