Data modelling Vs Dimensional modelling

Data modelling:
Modelling data storage optimized for Transactional Processing is Data Modelling

Dimensional modelling:
Modelling data storage optimized for Analytical Processing is Dimension Modelling..

SSAS: What is Named Query?

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 relating multiple tables

3. It helps to make the data source view with new table structure without modifying the underlying data source

SSAS: What is Linked Dimension ?

In SQL Server Analysis Services (SSAS), Linked Dimension is a dimension which is existed in other analysis services DB. It may exist in same or different server. it helps the user to keep the common dimension in multiple database.

What is Conformed dimension?

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


Example: Time, Product, Staff Dimensions are Conformed dimension, it is shared across multiple fact tables.

What is Role Playing dimension?

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

For example: Date dimension

Date dimension can be used for ordered date, shipping date, shipment date, and invoice date, etc., in an order line fact.

In the data warehouse, you will have a single dimension table for the dates. You will have multiple warehouse foreign key from the fact table to teh same dimension.

What is junk dimension?

A junk dimension is a collection of random transcational codes flags and text attributes that are unrelated to any particular dimension.The junk dimension is simply a structure that provides the convienent place to store the junk dimension.