Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Fact Table and Dimensions Tutorial

Posted on 2013-01-11
2
713 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

838 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