Dinesh's Blog :::: Being Compiled ::::
Showing posts with label
Dimensional Modeling
.
Show all posts
Showing posts with label
Dimensional Modeling
.
Show all posts
Thursday, July 28, 2016
SSIS - Fact Loading with Dimension Type II and Dimension Type I
›
The Dimensional Modeling in data warehousing, either using Star or Snowflake schema is still the most famous structure applied and widely ...
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...
Thursday, March 13, 2014
Who invented dimensional modeling?
›
Who introduced or invented Dimensional Modeling? Was it invented by Ralph Kimball ? Since he completely aligns with Dimensional Modeling in ...
Friday, January 24, 2014
Business Intelligence: Dimensional Modeling - Do we need Operational Codes as Dimension Attributes?
›
Business User: I need the product code as product name, whenever I use product dimension, system should default to the code, not the name, ...
›
Home
View web version