Re: Data warehouse - relations between dimensions

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 Mar 29 2000 - 00:00:00 CEST