Noobest question

Hi everyone

i know sql well yet i'm the noobest u can find in terms like DataWarehouse...

I just installed sql server 2005

got a database with 1 big table in it.

i was asked to "Build a data warehouse table based on existing table(s)..."

this setence has a sense to it ?

what the hell is a data warehouse table ... ?

i checked lots of sites and docs about data warehouse and feel kinda lost of all the info regarding stuff like "analysis service" "integration tools" "bi studio.." "reporting service" ....

where should i start in order to create this "data warehouse table" (no redundancy) i was asked to ?

Your help(+patience...) would be most appreciated - :-) thx .

That's a ridiculously vague thing to ask for. Who on earth gave you that requirement?

Its possible they were talking about a denormalised table. Some people might call this a pivoted table. Go and check those things out.

I doubt that "analysis service" "integration tools" "bi studio.." "reporting service" are relevant to you at this point.

-Jamie

|||If you are looking for infomation (basic to advanced) and documentation on the newest terms you are worrying, then refer to the books online that willbe installed alongwith your SQLServer tools. Make sure you are using latest version of books online in this case, for the latest one refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx link.