Skip to Main Content
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
book

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

by Whei-Jen Chen, Pat Bates, Timothy Donovan, Garrett Fitzsimons, Jon Lind, Rogerio Silva
October 2012
Beginner to intermediate content levelBeginner to intermediate
506 pages
12h 43m
English
IBM Redbooks
Content preview from Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
Chapter 4. Data modeling: End to end 87
4.2.2 Define the granularity
Stage two of the process is to determine the right level of detail that must be
contained within the model and ultimately, within the fact table. As an example, a
model might contain a complete record of a sales transaction as one entry within
the fact table, with all the products sold contained within the one entry or maybe
not even listed. In this case, the lowest level is be the individual sales transaction.
An alternative can be to set the product as the lowest level, thus requiring
multiple entries within the fact table to represent just one sales transaction. The
grain (detail) of the fact table has a significant impact on the data warehouse
from business, technical, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 0738437255Purchase book