Dimodelo Data Warehouse Studio Introduction
An introduction to Dimodelo Data Warehouse Studio, a Data Warehouse Automation and Agile Data Warehouse development tool
[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”][/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]Create an Employee Dimension using Dimodelo Data Warehouse Studio
This video demonstrates using Dimodelo Data Warehouse Studio to design, generate and execute an Employee dimension. It also explains the generated SSIS and DDL code.
[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”][/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]
Defining Derived Staging tables, Parent Child Hierarchies and Role Play dimensions
In this video we demonstrate using Dimodelo Data Warehouse Studio to define derived (or transform) layer staging tables, how to define a parent child hierarchy in a Dimension, how to use multiple staging tables from different source systems as the source of facts and dimensions, how to associate facts with dimensions and add role play dimensions.
[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”][/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”]
Create a basic Staging table using Dimodelo Data Warehouse Studio
Use Dimodelo Data Warehouse Studio to define a basic staging table using a table as a source and and the full extract pattern.
[/et_pb_text][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left”][/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]