Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17998 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
What is the difference between the public object&schema object?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is a bo repository?
What is the difference between datawarehousing and businessintelligence?
How to generate the report from excel sheet?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
what will be the contents for a functional requirements specifications
What we need to discuss with designer before starting the universe designing.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
what is xcelsius architecture?
Explain what are the steps to do to use alerts in bo?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Can we create universe with no cache??
Can anybody tell me what are the tuning problems?
Give some information on report bursting?
