asked on

Data Warehousing basic's

Hello Experts Exchange
I have started a new job and I need to build a SQL Server data warehouse, is there a web page that will tell me the basics of building a data warehouse?

I need to know things like what type of data goes in a fact and dimension tables?

Regards

SQLSearcher

tankergoblin

You need to create a SQL Server data warehouse? You want to do it alone?

It is a big project to me.

you not only need to create schema for sql but also you need to create interface for user to key in data and retrieve data, print report and so on.

Furthermore, if you create a new app from scratch then testing required and testing is the most time consuming part.

I suggest you to get a customize ERP or inventory management software

Kent Olsen

Hi Searcher,

Not to be too hard on you, but you need help with this. Not the question, but the actual work.

A data warehouse is so much different than a typical OLTP that you can't design and build one without quite a few prerequisites. The fact that you're asking this question in a public forum indicates that you don't have that background. You need to be comfortable with designing databases, you need to understand data warehousing models, and you need to know how the customer intends to use the data warehouse.

- How much data is there?
- What's the nature of the business/data?
- What answers (reporting) do you expect from the data warehouse?

ASKER CERTIFIED SOLUTION

Vikas Garg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial