Re: Data warehouse - relations between dimensions

Check out The Data Warehouse Toolkit by Ralph Kimball (www.rkimball.com). There is a discussion in there on this topic.

RD

Markus Janscha wrote in message <8bt85d$223$1_at_gxsn.com>...
>Robert,
>
>I am dealing with a similar scenario. Please let me know should you get
 some
>valuable feedback.
>
>
>Thanks
>
>Markus
>Hale, Robert [CREST:5K46:EXCH] <rhale_at_americasm05.nt.com> wrote in message
>news:38E168B7.203124EC_at_americasm05.nt.com...
>> Hi All,
>> I'm putting together my first star schema and got a request from a
>> development team that I'm having a hard time arguing against. The
>> developers have requested relations between certain dimensions in the
>> star schema. These dimensions are used in an OLTP system to maintain a
>> toplogy and the developers want to maintain the relationship between
>> dimensions rather then sort through the records in a fact table to
>> determine related rows.
>>
>> To me, this seems to break the simplicity requirement of a Star
>> schema. Do relations between dimensions impact the efficiency of a data
>> warehouse design?
>
>
Received on Wed Apr 12 2000 - 00:00:00 CEST