WHY OPERATIONAL DATA STORE
Data Consolidation
Most of the companies are facing challenges of data consolidation as the data exists in many different places. They could be in the excel, data files, legacy systems and the core systems. The data differs in different data granularity, data structures and data formats.
Near to Real Time Data Frequency
Data Frequency is required to be near to real time as it supports 24x7 requirements. Operational Data Store does not store the historical data of the data attributes but not including the transactional data.
Central Repository
Operational Data Store serves as the central repository of integrated data from one or more disparate source systems. Operational Data Store is designed for queries on direct transactional data which serves for business operations purpose. It enables accelerated data distribution and supporting dynamic business data requirements. It is widely used as a platform for all operational data used by enterprise systems and applications such as Campaign & Marketing, Customer Portal, Customer Relationship Management and etc.
Data Quality
Data Quality can be offered as part of the Operational Data Store to ensure that it meets business and regulatory requirements.
Data Completeness
Data Accuracy
Data Integrity
Data Consistency
Featured Success Stories
One of the top conventional insurers in Malaysia
8
Source Systems
600+
Source Tables
800,000,000+
Average Daily Transaction
2014
Supporting Business Since
WHEN DATA WAREHOUSE
Management and business users would require the current and historical data for reporting and data analysis.
The data is restructured, aggregated and summarized to deliver excellent query performance and complex analytic queries
The design method used is mostly dimensional approach with Top Down design to support slice and dice capability and hierarchy presentation.
Data Marts can be further developed to serve for a single subject or business oriented functions which only draw data from limited number of tables or subset of data.
Featured Success Stories
One of the government bodies in Malaysia
16
Source Systems
50+
Source Tables
1,000,000+
Average Daily Transaction
2010
Supporting Business Since
Data Integration & Quality Solutions for Operational Data Store
&
Data Warehouse
Oracle and Informatica remain as the partner. We are specialists in Oracle Data Integrator, Oracle Enterprise Data Quality, Oracle Goldengate, Informatica Power Center, Informatica Data Quality and Teradata. We outline a road map, a living document for the success of the Data Governance, Data Management and Data Innovation Services for the client.
Want to know more?
Contact Us
