Loading Your Data Warehouse Fast and Convenient
Do you want to load your data warehouse fast and convenient? SQL Server gives you plenty of opportunities how to get that task done in an appropriate way. You will have a look at tools and commands like bcp, BULK-Insert, OPENROWSET, MERGE, and SSIS and see how to tune them for performance and how to secure the quality of the process and the quality of the data itself. In addition, you will see how to handle changes in the data source (slowly changing dimensions) to guarantee a data warehouse your users are happy to work with.
Sorry, there are no downloads available for this session.
Markus Ehrenmüller-Jensen has experiences with different customers of all types concerning datawarehousing, etl, and business intelligence as project leader and trainer since 1994. He is an educated software-engineer, graduated business educator and professor for databases and project management at HTL Leonding and fully certified as MCSE and MCT Alumni. Markus speaks regularly on international conferences and writes articles for well-known journals. He works as a business intelligence architect for runtastic since 2014 and co-founded SQL PASS Austria in 2013. Markus co-organized the very first SQL Saturday in Vienna in 2014.
The video is not available to view online.