Data Engineering, Interview, Data Modeling.
add new dimensions without altering existing structure. Cons: 1. Redundancy: Denormalization can lead to data redundancy in dimension tables. 2. Storage: The redundant data might require more storage space. 3. Maintenance: Redundancy can make updates and inserts more complex, potentially leading to