Basics - what are the steps to build the datawarehouse

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 66 of 111

what are the steps to build the datawarehouse

Total Answers and Comments: 3

Last Update: September 01, 2006 Asked by: stalin

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 24, 2006 22:54:51

BTS

RE: what are the steps to build the datawarehouse

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

Is this answer useful? Yes | No

August 29, 2006 16:07:52

prashanthmcr

Member Since: August 2006 Contribution: 1

RE: what are the steps to build the datawarehouse

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.

Is this answer useful? Yes | No

September 01, 2006 04:40:26

Sravan Kumar Gopisetty

RE: what are the steps to build the datawarehouse

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

Is this answer useful? Yes | No

Go To Top