September 1998 – Data Warehouse Architect

DBMS – September 1998 – Data Warehouse Architect

In last month’s column, I talked about the difficult modeling situation in which one dimension you want to attach to a fact table takes on multiple values for each fact table record. The most vexing aspect of the problem was that you often don’t know how many values the dimension takes on until you see the data itself.