Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
149 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 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

783 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