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

Data Scientist II – Cell and Gene Therapy

user | June 11, 2022

https://careers.chop.edu/job/Philadelphia-Data-Scientist-II-Cell-and-Gene-Therapy-PA-19104/896314300/

Categories: Uncategorized

Post navigation

← Job Description – Lecturer in Biostatistics (2201078)
How Biologists are Using Machine Learning to Study Cells →

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