Skip to content
All work
Data Engineering

A HYBRIDJOIN stream-relation join loading a star schema, then OLAP in SQL.

ETL and query code; the source CSVs are not in the repository.

JavaMavenMySQLSQL

Overview

Streams transactions through a HYBRIDJOIN-style join against master data, loads product, date, and customer dimensions plus a sales fact table, and runs drill-down, slicing, pivot, z-score anomaly, and view-based queries.