Guides
Data warehouse migration guides
Long-form guides written by the people who built Novuz. Each one draws on the estates we have assessed and delivered, and cites its outside sources.
Data warehouse migration: the complete guide to moving legacy logic, and proving it
A data warehouse migration costs what its logic costs, not what its data costs. Count every object, remove the dead code and band each object by complexity. Then move one self-contained domain first and prove it with a reconciliation report per object. Fix the price only after the whole estate is read, and cut over domain by domain so the parallel run ends on a date.
By Debjani Dhar and Ted Ghose · 16 minutes read
How to validate a data warehouse migration: a reconciliation playbook
Validate a warehouse migration by reconciling every in-scope object, not sampling reports. Pin both platforms to one input snapshot, agree tolerances first, and run tiered checks: schema, row counts, column aggregates, then sampled or hashed rows. Record pass, fail or review per object with cause and fix. Put the counting rule beside every percentage, and tie cutover to a written threshold.
By Ted Ghose · 15 minutes read
Converting T-SQL, SSIS, Teradata BTEQ and Hive: the patterns that break, and how to handle them
Most conversion failures come from a small set of patterns: cursors, dynamic SQL, error handling, session-scoped temp objects, case and NULL semantics, date boundaries and orchestration. Convert them with fixed, versioned rules so two runs give identical output. Send the edge cases to an engineer for approval. Prove each object by reconciling original and converted code on the same inputs.
By Ted Ghose · 17 minutes read
How to evaluate a data warehouse migration tool: eight proof requests and a scoring sheet
Ask every vendor for artifacts, not answers. Request a two-run diff, the counting rule in writing, a reconciliation report for an object you pick, and a dead-code list from your own estate. Then ask for the guarantee clause, a deployment diagram, the engineer-approval log, and the escrow and ownership clauses. Score them on a sheet with weights you publish first, using your own code.
By Debjani Dhar · 15 minutes read
Find out what your logic debt is costing you.
Every object counted, lineage, dead code and a fixed price in three business days. $3,000, credited.
Not sure which door? The scorecard takes ten minutes and tells you.