I had a fantastic time at the NJSQL chapter meeting! You folks in New Jersey certainly get a bad rap - I didn't see any greasy hair or thick gold chains - and nobody threatened to kneecap me if I couldn't solve their SSIS performance problem. Many thanks to Melissa Demsak, the members that attended, and SetFocus for making it all possible.
As the abstract said, I talked about the typical things asked of SSIS when loading a Data Warehouse: slowly changing dimension processing, surrogate key lookups for fact table loading, and performance tweaks. It certainly was a lot to cover - and since it was, I buried a bunch of links to supporting information that expanded on each topic in the slide deck. If you're looking for more information on any of the topics we covered, download the slides and look at the notes, and/or look at the resources slide near the end.
I'll be sure to let Melissa know when I'm in Jersey visiting family again...
Hi Todd - thanks for posting the slides and coming to the meeting -- I'm still upset that I missed it; a very relevant topic for me at the moment
ReplyDeleteThat's too bad! Please let me know if any of the links have any problems - and I just joined the dark side (Twitter), so you can always hit me up with questions @Todd_McDermid.
ReplyDelete