IFC05 SDM05A-06

How does denormalization benefit data access in a star schema?

Denormalization in a star schema adds some redundant columns to dimension tables, which makes accessing the data faster and simplifies writing basic queries.