In this on-demand virtual tour, Pat Callaghan, Technical Account Manager at WhereScape, shows how to design Virtual Information Marts over a Data Vault, on SQL Server, using WhereScape RED.
Discover when to virtualize vs materialize, how to assemble dimensions and facts over hubs, links and satellites & how to apply DV 2.1-compliant views that keep presentation in sync with the vault.
What you will learn by watching:
- Virtual vs materialized marts: data duplication, latency, compute cost, consistency.
- Type 1 dimensions: build from hubs plus current-record satellite views.
- Slowly changing dimensions: history views, temporal joins, and mixed Type 1+2 patterns.
- Using PIT tables and bridges: when to use them, snapshot filtering, and performance notes.
- Fact construction two ways: from links plus transactional satellites, or via a bridge view.
- Multi-source attributes: coalesce ordering across satellites to set source preference.
- Keys and joins: hash of business key for joins, handling surrogate key expectations.
- Templates: generate the SCD view SQL so you do not hand-code temporal logic.
- Platform-agnostic approach: SQL Server shown but same patterns on Snowflake, Databricks, Fabric, Oracle + on-prem or cloud.
What are you waiting for? Start learning now!
