Ph US: 323 521 4640 Asia Pacifc: +61 407 698 591 contact@dimodelo.com

Dimodelo Architect Introduction

An introduction to Dimodelo Architect, a Data Warehouse Automation and Agile Data Warehouse development tool

Create an Employee Dimension using Dimodelo Architect

This video demonstrates using Dimodelo Architect to design, generate and execute an Employee dimension. It also explains the generated SSIS and DDL code.

 

Defining Derived Staging tables, Parent Child Hierarchies and Role Play dimensions

In this video we demonstrate using Dimodelo Architect 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.

 

Create a basic Staging table using Dimodelo Architect

Use Dimodelo Architect to define a basic staging table using a table as a source and and the full extract pattern.