what is the difference btween olap and oltp?
Answer Posted / anand
OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high
OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP
Is This Answer Correct ? | 27 Yes | 0 No |
Post New Answer View All Answers
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
U r project in which stage in implementation?
what is universe null
8. How much supervision have you typically received in your previous job?
explain in detail about type 3?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between webi and infoview?
how to create reports on screech?
What is the difference between datawarehousing and businessintelligence?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
What is the difference in creating filters in designer and business objects?
What are the steps to be taken to schedule the report?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message