April 23, 2024 at 5:56 pm
Everybody (well almost) knows that if you want to learn the design patterns for building a data warehouse, you read a book like Ralph Kimball's "The Data Warehouse Toolkit". That book gives you a bunch of theory about Slowly Changing Dimensions etc... Is there a book that's sort of a companion to that where they walk you through implementing some of those things in your database? (The ETL book or something?)
Kimball's book is good, but a little practice stuff would be super helpful. (I see there's a 3rd edition... is it that much better than 2nd edition?)
Thanks!
April 24, 2024 at 6:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 8, 2024 at 3:16 pm
If I have some time, I plan to do something about that next year. Stay tuned!
August 5, 2024 at 7:42 pm
<checking calendar>
Nope, still 2024.
Drat!
September 9, 2024 at 6:53 pm
Martin,
have you read Joe Caserta's book on ETL (from the Kimball collection)? ISBN: 978-0764567575
I'm just trying to get my head around doing the ETL etc and building proper dimensional models in the data warehouse, and any good pointers on "do it this way, NOT that way". =)
Thanks,
Pieter
September 10, 2024 at 8:16 am
I haven't and can unfortunately not comment on it, but Joe is well-known and respected for his work with the Kimball Group. It would definitely not hurt to read his book.
In my opinion, you're going to have to be willing to do a lot of reading and a lot of experimentation...or pay for training/consulting if you'd rather fast-track your learning. Most of the people who are experts in this area have spent thousands of hours perfecting those skills.
September 10, 2024 at 9:08 pm
thanks Martin. I'll probably just get a used copy. If I don't like it, I'm only out like $10.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply