Friday, March 23, 2012

Noob question - Data warehouse

Hi

i'm have the experience of 2 days with the term "data warehouse"

and i was asked to build a "data warehouse table - no redundancy".

i have sql server 2005 64 bit.

windows 2003 server 64 bit.

I built 1 database with 1 big table in it.

yet,i haven't got a clue wheather that previous sentence even has a sence to it (all i got from online reading is cubes..dimensions.. etc..nothing about "a data warehouse table"....).

The guy who asked for that table doesn't have experience in that field also so we might be wasting our time with the wrong terms...

Help would be appreciated. :)

thx.

Hi,

Sounds to me that the guy just used a buzzword without knowing anything about it. Ask him what he really wants to acheive, and I would guess that he'll answer analyse the data more easily. In that case read Sql Server 2005 Analysis Services tutorial. An SSAS database will create the tables it needs for the dimensions of your cubes.
http://msdn2.microsoft.com/en-us/library/ms170208.aspx

By the way there is a contradiction in what you said above:

<quote>
no redundancy ... I built 1 database with 1 big table in it
</quote>

No redundancy means that the database is fully normalized, meaning lots of tables.

Where is your data currently located? Another Sql Server database? If not maybe what he wants is to move all the data to a database.

Good luck,
Charles

sql

No comments:

Post a Comment