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

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.