>>>>To me it looks like they're distinct lookup values per column. A star schema might be enough to do in a single table:
>>>
>>>LookupGroup, lookupValue, description
>>
>>I looked up star schema, but it wasn't as clear to me as I had hoped. Does it mean that I would have to have a dimension table for each unique LookupGroup in the driver table? How is this better?
>
>I didn't say it's better (though IMHO it is:). In a star schema you use a single table for multiple lookups. A simple example would be:
>
>

>lookupGroup lookupValue Description
>----------- ----------- -------------------
>Gender      F           Female
>Gender      M           Male
>AgeGroup    1           0-10 years old
>AgeGroup    2           11-20 years old
>AgeGroup    3           21-30 years old
>AgeGroup    4           31+ years old
>

>
>select lookupValue as 'Gender',Description from myStarTable where lookUpGroup = 'Gender'
>
>To get individual groups as a table. If you cross join 'individual group table's you get all the combinations possible.

I think I know what you mean. I could use the table that I first defined, then run SQL on whatever loop, segment and value that I was interested. Or do a seek instead. Is that what you mean?