What is an OLAP (On-line Analytical processing) system?
- 1 Answers
- 4471 Views
- I also Faced
- E-Mail Answers
Answer Posted / azhar
It stands for OnLine Analytical Processing.It is used for
analysis and decision making.It contains past and
historical data.Data is is non volatile.It is used to
generate Investigation Reports.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is cubes?
Explain what are the steps to build the data warehouse?
Explain what is partitioning? What are the types of partitioning?
How can you set the session management?
What is a source qualifier?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is conformed fact?
What is difference between model & package?
Is there any rownum object from which we can do this?
Difference between cold fusion 5 and cold fusion mx 6?
Why facts table is useful in representing the data?
Explain difference between data ware house & data mart?
What is the main difference between star and snowflake star schema? Which one is better and why?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain can a dimension table contains numeric values?
