What are the 3 main differences between OLTP and Data warehouse in SAP BODS?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

What are the 3 main differences between OLTP and Data warehouse in SAP BODS?
Question Posted on 28 Nov 2020

Home >> SAP >> SAP BODS >> What are the 3 main differences between OLTP and Data warehouse in SAP BODS?

What are the 3 main differences between OLTP and Data warehouse in SAP BODS?
There are 3 main difference between OLTP and OLAP system and base of difference is given below
(1)Indexes:-OLTP system has limited number of indexes and on another hand OLAP system have many indexes for performance optimization.
(2)Joins:-When we say about OLTP systen there are large number of joins and data is also normalized and on another hand OLAP system have very less number and joins and it is de-normalized.
(3)Aggregation:-When we say about OLTP system data is not aggregated while in OLAP database more aggregation are used.