Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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: Friday, November 4, 2016 9:20 AM
Points: 36, Visits: 145
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."

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

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

Add to briefcase

Permissions Expand / Collapse