SSIS Design Patterns for Loading a Data Warehouse

Share URL
Embed Code
Share by Email
Send to social websites
Report this video as inappropriate You can report this video if you think it to be inappropriate, we will review your submission soon. If your reason is not listed here, like copyright infringements, please contact us directly by email. Select your reason
Sexual Content Violent or Repulsive Content
Hateful or Abusive Content Harmful Dangerous Acts
Child Abuse Spam
Uploaded by Keith on 8/5/2015
Loading a data warehouse can be a tricky task. A system that tracks history on some tables and keeps daily snapshots on others requires planning from the business and the developer. With all the requirements gathered it’s time to start building! Join us as we load type 1 and type 2 dimensions, fact tables and create a master package framework to control it all. We will explore the built in tools, like the slowly changing dimension wizard, then tell you all about why it should be avoided and show how to replace the functionality with much faster components. You will also learn how to handle special business scenarios, such as late arriving dimension members, in a variety of ways. After loading your warehouse come back and learn how to consume this data in SSAS.
Login to share your thoughts on this video, if you do not have an account please Register first.