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
92 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
򐂰 Nearly all dimensional models have one or more date and time dimensions.
These types of dimensions must be handled differently from other dimensions
such as geography or products. This is due to the additonal attributes that can
be applied to date and time dimensions.
򐂰 If a dimension table includes a code then, where possible, include the code
description as well. For example, if a product is identified by a product code,
and each code represents a product name, include both the code and the
product name in the dimension table.
򐂰 Normally, avoid having dimensional models include more than 10-15
dimension tables. If your model has more, look for dimension ...
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