what is the difference btween olap and oltp?
Answer Posted / jansi
OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed.
OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
What task is 98% of the required work of a business analyst?
what will be the contents for a functional requirements specifications
in sap bi we have wad, then why we go for sap bo
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain is data mart?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what is universe null
Explain when to use local filter and when to use global filter?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is object stores?
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?
What is package in BO
How to execute the plsql procedure from the report by clicking with mouse?
Explain what would you consider as your biggest achievement and why?