Data Integration is the set of collection and technologies that manages the transformation of information opposite the IT landscape. Historically, this has been completed with absolute Extract, Transform, and Load (ETL) collection that operated essentially in lot mode. More recently, these collection have developed in to nearby real time information transformation and have been assimilated by technologies written is to real time enterprise. What they all have in familiar is that they well pierce the information from source to destination, adding information high quality capabilities along the way.
Data Integration is necessary for MDM in that it loads, updates and helps automate the origination of MDM information hubs. MDM moreover utilizes information formation for formation high quality processes and metadata administration processes to help with information descent and attribute management. In addition, Data Integration is used to link up the Master Data to the Data Warehouse. The full cross-reference confirmed in the MDM network is made existing to the DW around the Data Integration tools. This enables precise assembly opposite the key business objects. In addition, the chief information represents many of the leading measure upheld in the information warehouse. Better high quality dimension information improves the stating out of the information warehouse. What's more, Data Integration keeps the MDM dimension tables in synch with the DW fact tables and supports joins opposite these two domains. Data Integration is moreover used to stock chief information attributes subsequent by the methodical estimate in the information storage area and by the various methodical tools. This information becomes right away existing to the related applications and business processes. This is infrequently referred to as 'Operationalizing' the DW.
Oracle MDM utilizes the Oracle Data Integration Suite (ODI) for its information formation needs. ODI provides a entirely one answer for building, deploying, and handling intricate information stores. In addition, it combines all the elements of information integration--data movement, information synchronization, information quality, information management, and information services--to make sure that information is timely, accurate, and conform to opposite intricate systems. What's more, Oracle Data Integrator Enterprise Edition delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance, reduces information formation costs, even opposite dissimilar systems. This creates ODI the best selection for 1) loading MDM Data Hubs, 2) populating information warehouses with MDM generated dimensions, cross-reference tables, and hierarchy information, and 3) relocating key methodical results from the information storage area to the MDM Data Hubs to 'operationalize' the information.
No comments:
Post a Comment