The Data Warehouse Toolkit

Третье издание классического руководства по dimension modelling: от основ до разбора сложных случаев.

Цитируем:

«Once you identify the attributes you want to remove from the base dimension, the initial mini-dimension build is easily done using the brute force method in the relational database. Simply create a new table with a surrogate key column, and populate the table using a SELECT DISTINCT of the columns from the base dimension along with an IDENTITY field or SEQUENCE to create the surrogate key».