Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 18217 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
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
Explain in detail about type 2(scd),
explain in detail about type 3?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how get the grand total in master-detail report?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is the difference between user and versatile user?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain when we use aggregate awareness function in designer?
What is Indexing? how did u implement indexing?
How to execute the plsql procedure from the report by clicking with mouse?
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 ?
Explain what is the difference between business requirement document and use case document.
How were the reports scheduled and how to resolve unexecuted documents?
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??
