Conformed Dimensions vs Dependency Explosion
Reddit r/dataengineering4w4 min read
Alright everyone, lower your voices. Bring it in. Let’s talk about the thing no one in data engineering is talking about right now. JUST KIDDING! Not another slop post. For years I build independent data marts and the Kimball strategy was clear, associate each fact with as many dimensions as possible, reuse dimensions across facts as much as possible. Fill in the squares in the bus matrix. But with a modern 3 layer data lakehouse in the cloud in a big enterprise, it can't all end up as one big star because the dependency explosion will slow down changes. So you separate the stars by business c
