Dinesh's Blog :::: Being Compiled ::::
Showing posts with label
Dimension
.
Show all posts
Showing posts with label
Dimension
.
Show all posts
Thursday, August 3, 2017
Script for creating DimTime Dimension Table and populating data
›
The posts I made on date dimension table ( Script for populating Date Dimension with Financial Year and Loading Data Script for Snowflak...
Saturday, May 16, 2015
What is a Junk Dimension?
›
Dimension represents entities that will be used for analyzing facts in the data warehouse. There are different type of dimensions like Reg...
Thursday, May 14, 2015
What are the reasons for introducing a surrogate key to a dimension table?
›
When designing a dimension table such as Product and Employee in a data warehouse, a surrogate key is introduced for implementing an uniqu...
Sunday, April 6, 2014
Reasons for adding a surrogate key for dimension tables
›
As a best practice, we always add a new key, known as a surrogate key to dimension tables for identifying the records uniquely. However, gen...
Sunday, April 17, 2011
Ordering Attribute Members of Dimensions in Analysis Services
›
As each attribute in a dimension can have a key column and optionally name column, attribute can be sorted by either key or name column. Sor...
2 comments:
›
Home
View web version
