how create Cubs ?What are Fact tables and Dimension Tables?

Posted by Sagarp under Sql Server on 2/27/2010 | Views : 3752 | Status : [Member] | Replies : 4
Hi



i will try to learn SSIS .plz tell me how to create cubs ,and What are Fact tables and Dimension Tables?
reply article.

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/



Responses

Posted by: Abhi2434 on: 2/27/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
I think you should buy a book on Data Warehousing and read.

For ur info :

Fact table give you the basic idea of net profit margin of a business.

Dimension table shows you the categorization to define each constituents of the Aggregate measure revealed in Fact table.

:)

www.abhisheksur.com

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bubbly on: 2/28/2010 [Member] Bronze

Up
0
Down
Hello,

Start the BI-Developer Studio (Programs/SQL Server 2005) -> Choose File/New Project -> Choose Analysis Services 9 project. -> After these steps you normally start with the dimensions.

This link can also help you:

http://www.databasejournal.com/features/mssql/article.php/3553971

++
Thanks & Regards,
Deepika

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Abhi2434 on: 2/28/2010 [Member] [Microsoft_MVP] [MVP] Silver

Up
0
Down
Hey,

The article seems to be great. Thanks for the link...

Cheers.

www.abhisheksur.com

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bubbly on: 2/28/2010 [Member] Bronze

Up
0
Down
Hello Abhi2434,

Happy Reading the article!!

++
Thanks & Regards,
Deepika

Sagarp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response