What is an OLAP (On-line Analytical processing) system?
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
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What function should we use to display the value entered or selected by a user in response to a prompt?
What are the different problems that ?Data mining? can solve?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is index awareness in universe?
What is Cognos script editor?
What are the other names given to data warehousing?
What is difference macros and prompts?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the methodologies of data warehousing?
Explain the difference between dw and bi?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are Non-additive facts?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.