In the process of Data Mart Consolidation, the areas that needs to be assessed and consolidated are the

  1. Data Model
  2. Data Integration Process and
  3. Reporting Layer

Let us define the following

  • Parent Data Mart – The Data Mart which is to get extended with the elements from another ( Child ) Data Mart
  • Child Data Mart – The Data Mart which is to be merged with the Parent Data Mart

The key analysis that needs to be done in the process of Data Model consolidation is

  1. Collect the data elements from the Child Data Mart data model
  2. Determine the source elements for each of the elements in the Child Data Mart
    1. The Data Integration metadata has to be analyzed to determine the source elements
  3. Determine whether any identified source system that feeds the Child Data Mart also feeds the Parent Data Mart
  4. Determine whether the Parent Data Mart receives data elements from any other source system that performs the same function as the identified source system of the Child Data Mart
  5. Collect the tables and data elements from the Parent Data Mart only based on point 3 and 4. Determine the data elements from the Parent Data Mart that has a overlap with the elements in Child Data Mart
  6. Determine any differences in the data type, format and data length between the similar elements in both the marts
  7. Determine the tables and elements in the Child Data Mart that are not used in the reporting layer. The identified tables could be intermediate staging or work tables and as well tables that can be possibly retired
  8. Determine the tables and elements in the Child Data mart that do not have a data integration process defined. The indentified tables could be candidates that are being currently maintained through a manual process and would require an automation process to be designed

Once the output of the above steps is available then the actual activity of data model consolidation between the two systems can be started. .

Posted by Muneeswara C Pandian
Comments (0)
October 22nd, 2009

Comments (0)