So you've been doing your datawarehousing in its traditional sense. You have your ETL set up to start after business hours, load all the new and updated data to have your datawarehouse ready and up-to-date for your business users when they start work the next day.
Now, you're asked to take things to the next level, they want to track data changes when they occur during the day so the DWH is always reporting on the latest data. Event-driven ETL to the rescue, as any type of event in the source system will need to trigger only that specific subsection of your ETL so it doesn't try to load your entire DWH every time one source changes.
In this session we'll explore the possibilities to set up a metadata-based solution to start specific subsegments of your ETL for any source system event and guide you through how a possible framework would be set up to facilitate this.