Interview question asked to Data Scientists interviewing at SeatGeek, Pluralsight, UberEats and other companies. Original question asked: Describe the ETL logic required to keep a heavily denormalized dimension table synchronized with its highly normalized source system..