Data Vault Express

This 2 day instructor-led course is for any Data Vault Developer who wishes to use the automated features of WhereScape 3D and WhereScape Red to create their Data Vault.

ABOUT THIS COURSE

The course includes using WhereScape 3D to discover, profile and document a source system database, capture user stories, build a model conversion, design the dimensional model, design the Data Vault (automation) and export the resulting XML to WhereScape RED.

In WhereScape RED you will learn how to build the entire Data Mart as well as creating a scheduled job to populate the data from the source system, through the Data Vault and into the Data Mart.

Finally you will create and display the fully documented DV and DM.

Audience

Data Warehouse Developers

Duration: 2 days

Versions: 8.0.1

Prerequisites: None

COURSE CONTENT

WhereScape 3D Installation

  • Install WhereScape 3D
  • Apply the license
  • Enable all functionality

Discover, Profile and Document a Source System

  • Create a local repository in 3D
  • Discover and profile the source database
  • Modify the source system diagram
  • Use 3D to understand the relationships
  • Document the source database as HTML

Capture User Stories

  • Create user story, business rule, interview
  • Add an observation note
  • Add an interview record
  • Document as a word document

Build Model Conversion

  • Setup a physical model
  • Import the source system
  • Modify column properties
  • Build a new model conversion
  • Add it to the conversion rules
  • Modify an existing conversion rule

Design Dimension Model

  • Create a new category
  • Add a star schema
  • Add predefined tables for date dims
  • Add dimensions and generate joins
  • Create the fact definition and joins
  • Create the artificial keys
  • Generate star schema documentation

Design Data Vault

  • Build the data vault model
  • Create new categories
  • Create the data vault
  • Import from the physical model
  • Apply the model conversion from 3NF to DV
  • Generate app for WhereScape RED
  • Add a RED design
  • Import from the DV model
  • Apply model conversion for load and stage
  • Export to WhereScape RED
  • Install WhereScape RED
  • Create SQL server database
  • Add ODBC source entry
  • Install the metadata repository
  • Install the application package
  • Rebuild stage, hub, link and satellite stored procedures

Building the Data Mart

  • Setting the data mart processing parameter
  • Create the stage tables for dimensions
  • Create the dimension tables
  • Create the role playing date dimension views
  • Create the stage table for the fact
  • Create the fact table
  • Install the scheduler
  • Create and run the end-to-end job
  • Create and display the fully documented data vault and data mart

Tell Me, I’ll Forget;
Show Me, I’ll Remember;
Let Me Do It, I’ll Understand

Scheduled Courses
No event found!