Interview question asked to Data Scientists interviewing at Amgen, Mailchimp, Calm 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..