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
115 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL: Episode III - Revenge of The Dude 24 53
SQL Error - Query 6 25
Oracle Insert not working 10 27
Oracle function to insert records? 15 39
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

776 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