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

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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/

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	Hello Abhi2434, Happy Reading the article!! ++ Thanks & Regards, Deepika Sagarp, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts