Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 26
  • 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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