what are the facilities provided by OLAP to analytical users?
Answer Posted / maruthi
1.)MULTI-DIMENSIONAL ANALYSIS
2>)AD-HOC QURIES
3.)REDUCED REDUNDANCY
4.)AGGREGATED DATA
5.)SECURITY
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the etl testing operations includes?
Which transformation we use to convert 'NA' to 'Not Available'
Explain the difference between etl tool and olap tools?
Define Dynamic push down optmization?
What is the difference between Data Warehousing and Data Mining?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Explain do we need an etl tool?
How many steps etl contains?
how do u set partition points in the mapping?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is a lookup table in etl?
How to delete data which is not in source table?
what is the difference steps for data modeling?
what is an ETL or ETT? And what are the different types?
List few etl bugs?