What are fact tables? Y is it neccessary for Cubes....

HAI
i have read about few pages in Microsoft dataware housing toolkit by ralph
kimball.i find it little difficult and vague to understand the concepts.so i
kindly request anybody who have worked with dataware housing to recommened

Hai
  i have just started to learn about the concepts of dataware housing. i
came to know there are about 5 services in data warehousing.
Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4

hai
 can you get give me some ideas for constructing a fact table for dataware
housing.And also about the different types of measures in the fact table
like full additive measures,semi-additive measures and fact-less fact table

hai
 can we use our relation tables as our dimension tables.or is there any
procedure to convert relational table to dimensional table.
thank you

When I deploy a cube it starts processing then comes up with the error
"connection was either timed out or lost". This also manages to stop the
Analysis Services Service on the Server.
Any ideas?

Is there a way to have changes that were made directly to an analysis
services 2005 database be reflected in a project without having to do
all the changes agian directly to the appropriate project?

What can I use instead of "Ignore" function, which I could find in AS 2000,
in SQL AS 2005.
Regards.
Sebastian

I was asked this question : " How will you go about optimizing Star Schemas
?". I understand data warehouses and understand what a Star Schema is.
However, I was not sure how to address this question.
Can someone point me in the right direction.

My question is about database partition.  I know how to define a filegroup,
Partition Function, Partition scheme and do a partion on brand new table.
But my question is how can I partition a existing table without droping it!!
Thanks for help