What do you feel is the best way to manage a data warehouse? Our team has limited resources, but are currently hindered with development work as we are doing so much operational work such as loads and upgrades. Do you feel operational and developmental work should be managed by two separate teams?


Sid Adelman's Answer: In the data warehouse world, there are "best practices" and "worst practices." If you are suggesting that the data warehouse team also have the responsibility for managing existing operational systems, you have perfectly described one of our favorite worst practices. The team needs to be dedicated to building a data warehouse, not being burdened with other responsibilities. Once a data warehouse is built, the loads should be turned over to operations (along with excellent procedures and documentation). Upgrades to the software, depending on which software (upgrades to the RDBMS, ETL tools, etc.), should be handled by the software specialists, not by the data warehouse development team.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access