How is OLAP application different from OLTP application?
Answer Posted / guest
OLAP:online analytical process
1.by using we can summarize the data.
2. we can analysis the report.
3. more faster then OLTP report.
OLTP: online transactional process
1. it is haveing only raw data.
2. it provide the item level data.
3. ganarate the report.
4. we won't summarize the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which of the tables are inside and outside cube in an extended star schema?
List the steps to do the converting from lis to lo extraction.
What are transfer rules?
What is the use of rollup?
Hi, I need to know anything and everything abt datamarts and thier behaviours. Please suggest any links/whitepapers/articles which explain datamarts from scratch. This is required for my admin job at hand. Appreciate your help :)
What are the template options?
When is idoc data transfer used?
hierarchies are not there in bi?why
How does it do delta?
Does it have delta facility?
What are the do?s and don?ts?
What is the procedure to implement structural authorization in BW?
what are the benefits of cubes?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
Can you tell something about the data ware-house hierarchy?