|
This may look like a staid scenario, but even today more than 80% of the enterprises are working on this set-up.
This is the most basic of the information delivery topology and does not include any Data Warehouse OR a Data Mart. As per this topology, data is pulled out from the source systems and placed in a common staging database. Most of the organizations have this level of basic topology. This is not a strategic decision , but an inevitable operational need. This topology can provide excellent source of production/schedule reporting and also some degree of low intensity analysis using front-end analysis tools.
There can be following levels of sophistication:
Basic Level
Objective is to have offline reporting to ensure no impact on production and have reporting across the systems.
- The entire set data tables are cut & paste from the source systems. It may not however, include the log and other control tables.
- No historical information. This is typical overwrite.
- Data is in as much normalized state as the source systems.
- No Transformation OR standardization of data.
- No aggregates.
- Standard & scheduled production reports.
Medium Level:
Objective is to have more sophisticated and cleaner staging and also allow some level of aggregate analysis. This should allow the reports covering the time spans.
- Data is pulled out selectively in terms of tables and fields with in the tables.
- The historical data is appended.
- Data is in normalized state.
- Some derived attributes and aggregates are generated.
High Level:
Objective is to provide a clean repository with a level of standardization & uniformity. It has the following additional features:
- The interlinking of diverse Customer codes, references, product codes etc. by changing the codes OR by creating the mapping tables. This enables a true-blue enterprise wide reporting.
- Medium level of Cleansing of data. This means that the key
- Many derived attributes and aggregates.
If an organization has reached to the “High Level” state (without any Data Warehouse), it has progressed at least 30% of the journey in achieving Information Management journey. By this time organization has understood most of quality issues and resolved some of them. The reporting teams have gone through the first set of Extraction and Transformation experience.
|
