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
131 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
[X]
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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
error starting database services 3 22
Oracle - BLOB Extract Line 2 22
Intermittent OleDbConnection Error 20 54
Need definitions 2 20
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

752 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