Microsoft Business Intelligence

Data modelling: Modelling data storage optimized for Transactional Processing is Data Modelling Dimensional modelling: Modelling data st...

1. Named Query is a SQL Statements and it act as a another table 2. It is formed by selecting rows and columns from single tables or relat...

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