Why a Data Warehouse is Separate from Operational Databases (Transacti

1.	Why a Data Warehouse is Separate from Operational Databases (Transaction Systems)?
Answer» A Transactional system is designed for known workloads and transactions like updating a user record, searching a record, etc. however a Data Warehouse transactions are more complex and present a general form of data. A Transactional system contains the current data of an organization and Data warehouse normally contains the historical data. Transactional system supports parallel processing of multiple transactions. Concurrency control and recovery mechanisms are required to maintain consistency of the database. An Operational database query allows to read and modify operations (delete and Update), while an OLAP query needs only read only access of stored data (Select statement). Data Warehousing involves data cleaning, data integration, and data consolidations.

Why a Data Warehouse is Separate from Operational Databases (Transaction Systems)?

Answer»

A Transactional system is designed for known workloads and transactions like updating a user record, searching a record, etc. however a Data Warehouse transactions are more complex and present a general form of data.

A Transactional system contains the current data of an organization and Data warehouse normally contains the historical data.

Transactional system supports parallel processing of multiple transactions. Concurrency control and recovery mechanisms are required to maintain consistency of the database.

An Operational database query allows to read and modify operations (delete and Update), while an OLAP query needs only read only access of stored data (Select statement).

Data Warehousing involves data cleaning, data integration, and data consolidations.

Discussion

No Comment Found

Related InterviewSolutions

What are the different ways of assigning permissions to OBIEE repository?
Is it possible to create outer join in Physical layer?
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer?
What is the difference between OBIEE 10g and OBIEE 11g administration?
What are different Application roles in BI system?
What is OBIEE Security? How do you define a Security policy in OBIEE system?
What do you understand by Data Level Security and Object Level Security?
What do you understand by connection pool and how many connection pools did you have in your last project?
What is the use of Column Prompts? Where they are used?
What are Inline prompts?