DiLytics interview question

SQL Server, Dataware concepts, ETL