SQLBits 2019

Using Change Tracking to build a Live Data Warehouse

How to build a Live Data Warehouse using Change Tracking capabilities
Tired of traditional DW ETLs that take hours or even days to populate your Data Warehouse and then keep your data static for reporting until the next ETL schedule runs? Your business is asking for live reports but your DW architecture is not designed for that and don't know what to do?Join us to know how we used Change Tracking to build a close to real time Data Warehouse. The challenges we experienced and how we tackled them.