Solved

12. Brief Summary Description on HOW TO Load Data into a STAR SCHEMA Data Warehouse..then PROCESS Cube?

Posted on 2014-10-16
1
107 Views
Last Modified: 2016-02-18
Experts:

You have an incremental data set that needs to populate into a Star Schema and then the corresponding SSAS cube needs to be processed. The STAR contains 1 fact, 4 Type two dimensions, 1 Time dimension, 3 Static dimensions, and 1 junk dimension. You need to be able to account for all incremental data in the STAR.

Walk through the process of loading the data and the steps of processing the SSAS cube.

Please only provide a BRIEF summary of how you would load this Star Schema and then processing the Cube.

Thanks!
0
Comment
Question by:MIKE
1 Comment
 
LVL 25

Accepted Solution

by:
jogos earned 500 total points
ID: 40386022
With "incremental load" you must think good about what you realy need. Just add the new data or also be able to update/delete data that has already been loaded. Lookup/conditionals split are the way to branch that path.

Only adding the new and new can be identified (ID > last ID, createddatetime .... ) then it is realy good for performance to test that so you don't evaluate all old data . But be aware if corrections can be made on old data it wont be populated anymore.

The dimensions you must evaluate if the it already exists  if not insert, if it does maybe something can be changed (address of customer)

An example of an incremental load
http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now