Session Title: Star Schema Automation in EDW/SqlPool
Speaker(s): Bob Duffy
Abstract: This session focuses on how to automate Star Schema creation, loading and extensibility using meta data based automation TSQL templates and DMVs.
Go from BUS Matrix to star schema with almost no coding at scale as we do for 10s of thousands of tables.
Note that we are focusing here on the Transform and Load parts of ETL, not the extract which is usually quite easy to automate.
500+ sessions are now available on-demand from Data Platform Summit 2022, 2021 & 2020 at no cost. Browse all sessions.
Stay tuned, more learning coming your way.