| |
| ||||||
FactsThis is a discussion on Facts within the F - I forums, part of the CAG - CORTEX Analytic Glossary category; When the team is defining the conformed dimensions, it's natural to discuss the various kinds of measured facts that exist in the various separate data sources. For instance, if several ... |
 |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
26th January 2010, 02:02 PM
| #1 |
| Administrator |  Facts When the team is defining the conformed dimensions, it's natural to discuss the various kinds of measured facts that exist in the various separate data sources. For instance, if several parts of the enterprise report revenue, then the assembled team is in a good place to discuss the exact definition of these different revenue measurements. Fact tables contain the fundamental measurements of the enterprise, and they are the ultimate target of most queries made into the data warehouse. Fact tables can be grouped into just three types: transaction grain, periodic snapshot grain and accumulating snapshot grain (the three types are shown in the figure [care of the Kimball organisation] below): |
|      |
|
| Bookmarks |
| Tags |
| facts |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Some Turkey Facts to Consider, and Why You Don't Want Al Gore Doing the Roasting | admin | Prediction Markets News Feeds | 0 | 26th November 2009 03:47 AM |
| Mining the Web for Feelings, Not Facts | BuzzNumbers | BuzzNumbers | 0 | 26th August 2009 06:53 AM |
| | |
| | |
Linear Mode
