Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dimension Tables vs Lookup Tables - the real difference? Expand / Collapse
Author
Message
Posted Friday, May 24, 2013 11:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:55 AM
Points: 30, Visits: 120
I'm reading about dimension and lookup tables and trying to get a better understanding between the difference. So far the best descriptor i have to separate these two tables is below. I would like to see if perhaps i'm missing something or if i'm understanding this correctly?

"For each dimension used in a project, a lookup table is required to provide meaningful information. For example, a "product" dimension might be based on a lookup table that includes the productID, productName, productType, productManufacturer, and so on. Dimensions define a hierarchy for the information retrieved by the lookup table, so that it can be organized and presented in a meaningful way."

Example:
Dimension table
VW -> Golf -> Features
VW -> Jetta -> Features
Honda -> Accord -> Features

Lookup table
Features
1 -> xxx
2 -> yyy
3 -> zzz
manufacturer
vw ->aaa
honda ->bbb
car
golf ->ccc
jetta ->ddd
accord ->eee
etc
Post #1456624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse