what are the facilities provided by OLAP to analytical users?



what are the facilities provided by OLAP to analytical users?..

Answer / 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

More ETL Interview Questions

what is the meant by Normalization and de-normalization?

2 Answers  


What are the three tiers in etl?

0 Answers  


Explain about enterprise scalability and roi of data integration suite?

0 Answers  


What are the steps involved in etl process?

0 Answers  


my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

1 Answers   HCL,






Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  


When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  


1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  


what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

0 Answers  


Categories