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
how to load the data to fact table?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is a staging area? What is the purpose of a staging area?
In Which Transformation We Can Use Having Clause In Informatica?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is the difference between Data Warehousing and Data Mining?
where is the cache (lookup, index) created and how can you see it.
What are the differences between sql override and update override?
what is granularity in Data ware House?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
Explain do we need an etl tool?
What is virtual Data Warehousing?
what is the difference between cubes and package in cognos