[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 27
  • Last Modified:

Help finding step by step book/solution for SSIS and Type 1 and 2 SCD

IS there any good books out there, that have detailed examples, on implementing SCD 1 and 2 in SSIS ? i have found a few books, that claim to be a soup to nuts solution for SSIS and ETL. but most of their instruciton is on Truncate and Load facts and dimensions, which is very good, if that's what you're company wants. But we are implementing SCD and it's tough to get my head around some of the concepts. Looking for a good book, article, or even attending a training class to work thru some of these examples.
0
Auerelio Vasquez
Asked:
Auerelio Vasquez
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I've taken Pragmatic Works free webinars before with some success.  Here's one on SSIS Design Patterns for Loading a Data Warehouse, and in the description it talks about Type 1 / Type 2.

I'm guessing that a YouTube search will return some, but most SSIS videos I've seen were of poor quality with speakers that can barely be understood.

Good luck.
0
 
ste5anSenior DeveloperCommented:
Take a look at these books from the Kimball Group.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your self study.  -Jim
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now