What Is The Difference Between Olap And Oltp?

1.	What Is The Difference Between Olap And Oltp?
Answer» OLTP is responsible for data COLLECTION where as OLAP purpose is to simply analyze and report on that data. OLTP are normalized SYSTEMS while OLAP are not that normalized. They are used for limited data with quick operations. Both these systems are highly reliable and can be considered in Data INTEGRATION without facing any ISSUE. OLTP is responsible for data collection where as OLAP purpose is to simply analyze and report on that data. OLTP are normalized systems while OLAP are not that normalized. They are used for limited data with quick operations. Both these systems are highly reliable and can be considered in Data Integration without facing any issue.

Answer»

OLTP is responsible for data COLLECTION where as OLAP purpose is to simply analyze and report on that data. OLTP are normalized SYSTEMS while OLAP are not that normalized. They are used for limited data with quick operations. Both these systems are highly reliable and can be considered in Data INTEGRATION without facing any ISSUE.

OLTP is responsible for data collection where as OLAP purpose is to simply analyze and report on that data. OLTP are normalized systems while OLAP are not that normalized. They are used for limited data with quick operations. Both these systems are highly reliable and can be considered in Data Integration without facing any issue.

Discussion

No Comment Found

Related InterviewSolutions

Tell Us The Prime Responsibilities Of Data Integration Administrator?
Can You Tell Us Something About The Dimensional Modeling?
What Is The Difference Between Olap And Oltp?
What Do You Call A Data Warehouse, What Is Its Purpose?
Do Data Integration System Models Have Layers In Them? What Is Their Purpose? Name Them?
What Data Tells You About The Structure Of Meta Objects? What Do You Know About Transaction And Master Data?
In Data Integration Approach, Is It Possible To Use Sap As A Database? Why Or Why Not?
How Many Stages Are There In The Data Mining, Name Them?
What If You Lost Any Data Which Is Important For Deriving Useful Information?
Suppose You Find Some Errors After Integrating The Data Through A Tool, Would You Repeat The Integration Process Again From Beginning Or Take Another Appropriate Action?