A
shrunk dimension is another sub-set. For example, the fact table for orders
which contain a foreign product main, but a foreign product segment, which is
in the product table, but which is much less granular may be included in the
target fact table. One way to deal with the heterogeneous grain condition is to
create a smaller dimension table that has the crop group as its primary key. If
the product dimension is black-snow, a different product type table is usually
available, which will act as the shrunk dimension.
We
can see it in the “AdventureWorksDW” Database.
|
SELECT * |
