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

What you've provided is very vague, but -- purely based on what you posted,
with no information about the size of data or various other concerns -- I
would definitely say the single table.

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--


<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
>
>

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
>
>