0 votes
10 views
What are the 3 main differences between OLTP and Data warehouse in SAP BODS?
in Technology by (186k points)

1 Answer

0 votes
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.
by (186k points)

Related questions

0 votes
1 answer 23 views
23 views asked Dec 11, 2020 in Technology by JackTerrance (186k points)
0 votes
1 answer 12 views
0 votes
1 answer 14 views
0 votes
1 answer 10 views
0 votes
1 answer 9 views
0 votes
1 answer 13 views
0 votes
1 answer 24 views
0 votes
1 answer 21 views
0 votes
1 answer 16 views
0 votes
1 answer 19 views
0 votes
1 answer 48 views
...