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 are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain how we drill up week to month?
Explain what are the steps to do to use alerts in bo?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
How to schedule the report in b.o?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is package in BO
how get the grand total in master-detail report?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How to execute the plsql procedure from the report by clicking with mouse?
How to create Index to the table in the universe designer and how it improves the Query performence