How to generate fact and dim tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SSIS and Import/Export (2012)

How to generate fact and dim tables

Author

Topic

Malini5
Starting Member

3 Posts

Posted - 2013-08-03 : 06:33:53

Hello!

I am very new to BI and I need to create a cube from the scratch. The main thing that I dont understand is how to generate fact and dimension tables? Any help would be really appreciated.

Regards
Malini

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-03 : 06:45:40

Do you've a datamart or a data warehouse currently? Or do you just have a few source tables which you need to use for cube creation?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Malini5
Starting Member

3 Posts

Posted - 2013-08-03 : 07:25:25

I have only source tables in the main database engine

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-03 : 07:33:12

then you need to first create a data mart for your cube creation. the tables will mostly be denormalised in data mart and will consist of fact tables containing the required measures and linking to various dimensions using key columns which will have foreign key relationships to dimension table key columns. The dimensions will also have attributes included.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Malini5
Starting Member

3 Posts

Posted - 2013-08-08 : 15:56:21

Thanks a loottt :)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-09 : 06:11:45

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-08-09 : 06:11:45

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources