| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Intelligence
| Print | |
Question: What is Hyperion? Is it an OLAP tool? what is the difference between OLAP and ETL tools? What is the future for OLAP and ETL market for the next five years?
|
| May 05, 2006 08:51:32 |
#2 |
| joys |
Member Since: Visitor Total Comments: N/A |
RE: What is Hyperion? Is it an OLAP tool? what is the ...
|
| There r only 2 ways available to get data from a datawarehouse or a database.one is using sql statement and other method is using an OLAP tool(ex:cognos, business objects.....)So Hyperion is an example for a OLAP tool. ETL is a process of Extracting data from a source systems(a system where client's transactional business information resides) and performing business logic(applying TRANSFORMATION rules) on the collected source information(business logic depends on business requirements), and LOADING the precise data into a warehouse(propably a relational database). OLAP comes into picture after ETL developers design the warehouse........by using olap tools a business user can generate standard reports(without having sql knowledge he can do this) |
| |
Back To Question | |
