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
is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7
How do start routine and return table synchronize with each other?
Does it have delta facility?
Tell something you know about the dimension in the warehouse and how it can be optimized?
What internally happens when bw objects like info object, info cube or ods are created and activated?
What is the process chain and when you can use the same in the data warehouse?
Give some examples of old LIS and new equivalent LO?
What is a number range object?
When i am executing process chain ,the pc takes data into the xml file and transfer to the next process..where this xml file is stored?
When you define aggregates, what are the available options?
How can a cube have partitioned for which the data already exists?
What is the function of the ‘reconstruction’ tab in an info cube?
which object based you created extended star schema?
What is the function of bw statistics cube?
Describe your experience with bw extractors