Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17680 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / balaji
OLTP
• Current data
• Short database transactions
• Online update/insert/delete
• Normalization is promoted
• High volume transactions
• Transaction recovery is necessary
• only one record is processed at a time
• data is present in 2d format
OLAP
•
• Current and historical data
• Long database transactions
• Batch update/insert/delete
• Denormalization is promoted
• Low volume transactions
• Transaction recovery is not necessary
• group of records processed at a time
• data is present in multi dim format
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Difference between b.o 5.1 and 6.1b?
What are the join problems comes appart from loop,chasm & fan Traps
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How to open a universe with out using the Designer ??
Explain is data mart?
Explain difference between zabo and webi?
what are the day to day activities of BO administrator ?
how get the grand total in master-detail report?
What is the difference between absolute and relative div positioning?
Explain about a time when you discovered a more efficient way to do a work task?
Explain when we use aggregate awareness function in designer?
How to create Index to the table in the universe designer and how it improves the Query performence
What is report template in b.o?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
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?
