Solved

Fact Table and Dimensions Tutorial

Posted on 2013-01-11
2
717 Views
Last Modified: 2013-01-18
Hi all ..
I have a Datawarehouse.. with about 1 million records.
With 4 Rational connected Tables.

I have created a simple star CUBE.
With 1 fact table and 3 dimensions..
I am looking for a way to automate the population of this tables with data from the Warehouse DB.

A guide, Informe of a tutorial or otherwise  will be appericated..

Thanks.
0
Comment
Question by:ZURINET
2 Comments
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 350 total points
ID: 38769059
0
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 150 total points
ID: 38777512
In case you'd like to get access to more details than what's mentioned online, I can really recommend the books by Ralph Kimball.  Especially the first three in that list. Have a look at the table of contents to judge which one would help you the most.

As tool, seeing you've got SQL Server, you'll probably be interested in Integration Services (SSIS).  In that perspective I'd recommend the books by Brian Knight and Erik Veerman.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question