A data architect is designing a data warehouse for a retail analytics team. The product dimension currently duplicates category, subcategory, and supplier names across millions of rows, and storage costs are rising. The team is willing to accept slightly more complex queries to reduce this redundancy. Which schema design should the architect adopt?