Transcription of Dimensional Modelling by Example - Database Answers
{{id}} {{{paragraph}}}
Example: stock market
Dimensional Modelling by Example - Database Answers
Dimensional Modelling by Example Page 1 04/09/2014 13:02 Dimensional Modelling by Example Barry Williams Dimensional Modelling by Example Page 2 04/09/2014 13:02 1. Management Summary .. 5 The Purpose of this Book .. 5 The Contents of this Book .. 5 Three Stages .. 5 What are Dimensional Models ? .. 5 Data Marts .. 6 Best Practice .. 7 Types of Dimensional Models .. 7 How to use the Dimensional Models .. 12 2. Getting Started .. 12 Design Guidelines - a Four-Step Approach .. 12 Always use Surrogate Keys.
Dimensional Modelling by Example Page 15 04/09/2014 13:02 2.3.3 Conformed Dimensions Conformed Dimensions are shared between Tables and must have the same values in order for Data to be retrieved satisfactorily. For example, date-stamped data in two tables must all be at the same level of granularity – for example, Days, Weeks or Months.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: