Noob question regarding "Data Warehouse"

Hi

i'm a total noob with the term "data warehouse"

i have 1 db with 1 big table in it.

i was asked from a guy who has no experience either with data warehousing to build a "data warehouse table - no redundancy"

i haven't got a clue how to do it or does this sentence even has a sence to it.

lots of tools on sql server 2005 yet, i don't know where to go in order to move this thing forward.

help would be appreciated.

Avi. :)

Refer to http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx about DW operations guide on SQL Server 2000 which can give you more information, for SQL 2005 as of now you can depend upon books online in this case, also this is an question with open answers and unless you have specific need it is hard to pinpoint the solution.

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

Noise Words

We were getting errors when users searched for the term "r&d" - with or
without quotes - so we removed all single-letter words from the noise
word files (.eng, .enu and .dat). We then started Microsoft Search
again and did a full population - "rebuild" was grayed out.
This stopped the error but now we get no results.
Questions:
1) Why are we getting no results?
2) Is "&" a word breaker? Can we change this?
Are there any messages in the event log from MSSearch or MSSCI?
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<s.cawood@.gmail.com> wrote in message
news:1143716799.014202.246690@.i39g2000cwa.googlegr oups.com...
> We were getting errors when users searched for the term "r&d" - with or
> without quotes - so we removed all single-letter words from the noise
> word files (.eng, .enu and .dat). We then started Microsoft Search
> again and did a full population - "rebuild" was grayed out.
> This stopped the error but now we get no results.
> Questions:
> 1) Why are we getting no results?
> 2) Is "&" a word breaker? Can we change this?
>