Chapter 18: Junk Dimensions


Overview

A junk dimension is a dimension that contains data with a small number of possible values. The sales order, for example, might have more discrete data (yes-no type values), such as

  • verification_ind (the value is yes if this order has been verified)

  • credit_check_flag (indicating whether or not the customer credit status for this order has been checked)

  • new_customer_ind (the value is yes if this is the first order of a new customer)

  • web_order_flag (indicating whether or not this order was placed online)

This type of data may often be useful to enhance sales analysis and should be stored in a special type of dimension called junk dimension.

This chapter discusses junk dimensions.



Dimensional Data Warehousing with MySQL. A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149

Similar book on Amazon
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Successful Business Intelligence: Secrets to Making BI a Killer App

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net