Skip to the content
From Statistics to Biostatistics
My journey from Applied Statistics to Biostatistics

DPhil in Genomic Medicine and Statistics — Wellcome Centre for Human Genetics

user | June 18, 2022

https://www.well.ox.ac.uk/study/gms

Categories: Uncategorized

Post navigation

← Research Associate Data Scientist – Urbanowicz Lab – Computational Biomedicine at Cedars-Sinai

RSS Data Vault 2.0

  • Bitemporal data in Data Vault
  • Data Vault Anti-pattern: Using a HASHKEY to generate the LINK HASHKEY
  • Data Vault Anti-pattern: Including Business Keys in the SAT HASHDIFF
  • Data Vault Anti-pattern: Adding column to the middle of the hashdiff
  • Data Vault Anti-pattern: Using Multi-Active SAT to model data with multiple records for the same Business Key that arrive one Micro-batch
  • Data Vault Anti-pattern: Having two or more records in a SAT for a Single Business Key with the same LOAD_DATE
  • Data Vault Anti-pattern: Adding Relationship Temporality to a Non-historised LINK
  • Data Vault Anti-pattern: Excluding the Dependent Child in the generating the LINK Hashkey
  • Data Vault Anti-pattern: Using Historized Links to store Transactional data that does not change
  • Data Vault Anti-pattern: Implementing Business Rules at the Infomart Level