12. Brief Summary Description on HOW TO Load Data into a STAR SCHEMA Data Warehouse..then PROCESS Cube?
Posted on 2014-10-16
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.