Describe the ETL logic required to keep a heavily denormalized dimension table synchronized with its highly normalized source system.

Interview question asked to Data Scientists interviewing at Asana, Juniper Networks, Visa 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..