Archives of the TeradataForum
Message Posted: Tue, 20 Mar 2001 @ 16:59:07 GMT
Quoting Kimball chapter and verse, there are other reasons for denormalizing dimension tables. One, is to make the model more understandable. Another is to make it easier on the reporting tools for generating SQL.
It seems to me there is a third reason: to integrate models from multiple source systems a good Kimball-esque star schema will be independent of the shape of any source model.
Does anyone on this list have an opinion on these reasons?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|