Hi Everyone,



Probably not everyone's cup of tea (or cup of whatever you drink across
the pond), but I've a conceptual issue with a data warehouse design that
hopefully some of you gurus will enjoy chewing over on this Friday aft.



We plan to have (amongst others) a deliveries fact, a delivery bank
fact, and a financial services fact, which hold different data at
different levels about an order. Where I'm struggling, is the best way
to link these facts together if we wanted to analyse measures from each
one?


There seems to be two options - either we have the order number as a
degenerate dimension on each table and use this to link with (but not
sure how), or have an order header dimension that links to each one?



Any clues on the best way to do this, general does/don'ts etc?



Any help greatly appreciated

Thanks
Rick



P.s. Happy Friday!



This email and any files transmitted with it are strictly confidential. It is for the intended recipient only. If you have received the email in error please notify the author by replying to this email. If you are not the intended recipient you must not disclose, distribute, copy, print or rely on this email in anyway. Any views which are expressed in this e-mail are solely the personal opinion of the author and do not necessarily represent the views of CC Automotive Group Limited. Registered in England and Wales No: 819414. Registered office: Nixon Street, Rochdale, Lancashire OL11 3JW. This footnote also confirms this email message has been swept for the presence of known computer viruses before transmission.

MS Sql Server LazyDBA home page