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
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 we need to discuss with designer before starting the universe designing.
What is a fantrap in business objects?
What are all difference between business objects 6.5 and xi r2?
What is difference between webi and infoview?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain when we use aggregate awareness function in designer?
Explain about a time when you discovered a more efficient way to do a work task?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between user and versatile user?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
explain in detail about type 3?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What are the steps to do to use alerts in bo?