MS SQL Data Warehousing - Re: Warehouse Structure

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Warehouse Structure

test

2005-04-12, 8:23 pm

I would suggest that datawarehousing principles would like to stress that
duplication is one of the most important things to consider when designing a
data warehouse.

Therefore 1 table would be the way to go.

Pending that it is possible.

Thanks

<brian.shannon@diamondjo.com> wrote in message
news:eOfIkYWMFHA.1096@tk2msftngp13.phx.gbl...
>I am in the first step of creating a data warehouse and am in an argument
> with my co-worker on structure.
>
> I have two locations both using sqlserver 2000. Each location has a
> location id. (1 and 2).
>
> I want to warehouse certian data about each location.
>
> I want to store data for both locations in 1 table and add the casino ID
> to
> the row. My co-worker wants to create a table for each location and
> always
> use UNION queries.
>
> What would the proper technique be considering the limited data i
> provided?
>
> Thanks
>
>

Sponsored Links