1 day ago
You confused me a bit when you said "normalize in the Silver layer". Yes, a star schema is more normalized than OBT, but the dimensions are somewhat denormalized compared to third normal form (TNF) used by properly architected source system tables. I do like the approach you suggest.





