Are you interested in learning more about loading dimension tables in SSIS? A recent webinar with Manuel Quintana, Training Content Manager at Pragmatic Works, dives into SSIS and takes a look at the different design options that are available for maintaining dimensions in a traditional data warehouse.
In the webinar, which includes demos, Manuel goes over the beginning elements of loading dimensions and reviews why your goal should be to move away from transactional, normalized systems and get into a denormalized data warehouse system.
Manuel not only teaches about the benefits of a dimensional model, but discusses dimension types, dimension tables and surrogate keys. He then spends time on demos about designing and loading a dimension.
You can watch the recorded webinar here to learn more. As you probably know, an hour-long webinar about anything to do with SSIS is only a drop in the bucket. Fortunately, the Pragmatic Works' on-demand learning platform training offers deep dive courses on SSIS (Intro and Advanced) and Data Modeling, along with more insightful content and training sessions on Power BI, Power Apps, Power Automate, Copilot Studio, Fabric, Azure and other Microsoft applications.
Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks, along with fresh content every week.
It's also incredibly easy to get started with your 7-day free trial. No credit card required. Just click below and you'll be on your way.
.
Leave a comment