Describe how you would design an ETL or ELT pipeline that loads data from several source systems into a warehouse. How would you handle schema changes, failed loads, and reruns without duplicating data?
Write your answer in the field below and click the "Check!" button.