April 12, 2000 09:06 AM

Relational to Dimensional

Rating: (0)
SQL Server Magazine
InstantDoc ID #8563
Follow this simple example to pull relational data into a dimensional data mart
You've heard the terms—data mart, dimensional database, star schema—but many people find that the how-to of data warehousing remains a mystery. If you haven't been involved in developing an enterprisewide data warehouse or a departmental data mart, you might have a hard time wrapping your mind around these concepts and how they translate into practical business solutions. So let's ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Useful one

Anonymous User 3/29/2005 12:11:55 AM


Very useful article.

Anonymous User 12/10/2004 7:10:05 AM


Your article helped me in designing and confirming my design steps in builiding a similar kind of data mart, which I was working on.

Anonymous User 11/9/2004 12:34:50 AM


Thanks for the article.It made most of the datawarehousing terms clear to me. Thank you.

Anonymous User 10/22/2004 1:23:31 PM


Thanks for the article.It made most of the datawarehousing terms clear to me. Thank you.

Anonymous User 10/22/2004 1:23:31 PM


This works:
DTSRUN /f Load_Northwind_Star.dts
Howcome I can't open it from Enterprise Manager?

J Gama 10/8/2001 7:20:47 PM


Your dtspackage in your Article is not ruunig.
Transform data spteps (products, customers end so on) are wrong.

A.Zentchenko 6/29/2001 5:01:55 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS