Q:

My customer information is spread over multiple systems on different platforms (Windows, UNIX, mainframe). The requirement is to create a customer data warehouse for dimensional analysis. Once the data warehouse is completed, the user group would like to use it as a master database for a single version of truth. They would like to change the customer information first in the data warehouse and then populate the corresponding source system for that particular customer. Does this make sense? What type of architecture should one follow? What tools are available? What is the possibility of using a tool like MQ series?

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