Q: We have almost completed the first iteration of our data warehouse base facts and dimensions. Our ETL developers use templates to assure consistency and accuracy in their code, and we have a very good QA process in place. It has been suggested that we should convert to an ETL tool instead of continuing on our current path. Given the amount of time and work that has already been invested into what seems to be a reliable process, is this a reasonable thing to do at this point in the project?

To buy or to build, that's the question! Considering the fact that you are almost done with the first phase of your DW, and that you have implemented methods and processes to assure data consistency, one would suggest to continue with the current plan. However, I suggest that you also consider the following conditions prior to making a decision:

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