When would you denormalise a data model?

When read performance and query simplicity matter more than write consistency — which is most of the time in analytical systems.

Star schema or one big table?

Star schema for a shared semantic layer; one big table for a single well-understood workload where join cost dominates.

Interview Lab

Pipelines, modelling, orchestration and trade-offs.

When would you denormalise a data model?
When read performance and query simplicity matter more than write consistency — which is most of the time in analytical systems.
INTERMEDIATEDifficulty: INTERMEDIATEData modelling
Star schema or one big table?
Star schema for a shared semantic layer; one big table for a single well-understood workload where join cost dominates.
INTERMEDIATEDifficulty: INTERMEDIATEData modelling