Had a discussion
this past week with some great colleagues re: the quality of the database
design of a potential source system (or lack thereof, depending on point of
view) I've racked my brain trying to
find an article that provided some caution in dealing with this. Almost sure it came from either a book or
article from the Kimball Group. I will
paraphrase it:
From
time to time, a data source will appear to warrant improvement of some
kind. The data source provider may be all for it. Couldn't that
spreadsheet be turned into a proper system?
Avoid
such efforts. Your team will be constantly distracted by work of a very
different cadence than that which data warehousing requires.
The closest I could
find was a snippet in “The Microsoft Data Warehouse Toolkit”, from the chapter
on Business
Requirements Example: Adventure Works Cycles (emphasis mine)
"….price
lists and international support are important issues to his organization, but
they are transaction system problems because they involve enhancing transaction
systems or building new IT infrastructure. You
can help with better reporting, but you shouldn't be dealing with connectivity
and data capture issues if you can avoid it. "
I have taken this
viewpoint into many battles over scope of a data warehouse project… I have not won all of those battles ;) Nonetheless, it’s a positive outcome to have
this caution incorporated into your mindset when evaluating sources. When possible move the system development
'out' to the proper parties as quickly as possible.
1 comment:
Casino Review & Bonus - JeTHub
You are welcome 포천 출장안마 to try your hand at a casino, with an 서울특별 출장샵 excellent 문경 출장마사지 gaming experience. Players from Canada can 울산광역 출장안마 play 상주 출장마사지 for real money on the casino floor.
Post a Comment