BTS

• Jul 24th, 2006

 

As far I know...

Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios

prashanthmcr

 Profile Answers by prashanthmcr 

• Aug 29th, 2006

 

You can also the book "The Datawarehouse Toolkit" By ralph kimball and margy ross. I found it extremely helpful.

Prashanth

Check the website www.intelligententerprise.com . It is quite informative and has very useful articles.

Sravan Kumar Gopisetty

• Sep 1st, 2006

 

1.Understand the bussiness requirements.

2.Once the business requirements are clear then Identify the Grains(Levels).

3.Grains are defined ,design the Dimensional tables with the Lower level Grains.

4.Once the Dimensions are designed,design the Fact table With the Key Performance Indecators(Facts).

5.Once the dimensions and Fact tables are designed define the relation ship between the tables by using primery key and Foriegn Key.In logical phase data base design looks like Star Schema design so it is named as Star Schema Design.

Thanks Sravan Gopisetty

09347524177