ETL - what is the difference between etl tool and olap tools

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Go To First | Previous Question | Next Question

ETL | Question 30 of 65

what is the difference between etl tool and olap tools

Total Answers and Comments: 10

Last Update: August 27, 2009 Asked by: anil rao

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 09, 2005 02:20:27

Rahiman

RE: what is the difference between etl tool and olap t...

ETL tool is ment for extraction data from the legecy systems and load into specified data base with some process of cleansing data.

ex: Informatica data stage ....etc

OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional model. so that u can write smple query to extract data fro the data base.

ex: Businee objects Cognos....etc

Is this answer useful? Yes | No

November 30, 2005 00:55:48

Prakash

RE: what is the difference between etl tool and olap t...

ETL tools are used to extract the data from different sources & OLAP tools are used to analyze the data ......

Is this answer useful? Yes | No

January 03, 2006 03:21:47

sithu

RE: what is the difference between etl tool and olap t...

ETL tools are used to extract transformation and loading the data into data warehouse / data mart

OLAP tools are used to create cubes/reports for business analysis from data warehouse / data mart

Is this answer useful? Yes | No

January 10, 2006 04:06:49

sithusithu

Member Since: December 2005 Contribution: 161

RE: what is the difference between etl tool and olap t...

ETL tools are used to extract transformation and loading the data into data warehouse / data mart

OLAP tools are used to create cubes/reports for business analysis from data warehouse / data mart

Cheers

Sithu

Is this answer useful? Yes | No

August 03, 2006 08:28:10

kishore Penchalapadu

RE: what is the difference between etl tool and olap t...

ETL tool stands for extract transform load

ETL is independent some steps may be skipped while loading

its process done before creating warehouse

OLAP is recovery tool

It needs queries

It is dependent on ETL

Is this answer useful? Yes | No

August 11, 2006 02:05:13

Shobhit

RE: what is the difference between etl tool and olap t...

ETL >Basically ETL provides the plateform to bring data from Datasouce to trageted data server. ETL helps to extract data from within system and out of the system.

OLAP: takes place after Data gets loaded into Datawarehouse. then after cube processing same would be ready for reporting purpose

Is this answer useful? Yes | No

August 15, 2006 18:08:28

Laxman

Need Information on ETL & Informatica

Hello Situ

Where can I get Information to learn ETL testing and Informatica?

Is this answer useful? Yes | No

October 10, 2006 13:00:03

rajkumar

RE: what is the difference between etl tool and olap t...

ETL tool is used to extract the datas and to perform the operation as per our needs for eg : informatica data mart but OLAP is completely differ from etl process it is used for generating report also known as reporting tool eg: bo and cognos.

Is this answer useful? Yes | No

June 16, 2007 19:43:48

Sujatars

Member Since: December 2006 Contribution: 217

RE: what is the difference between etl tool and olap t...

ETL tool is used for Extration Transformation(filtering) and loading the data into data warehouse .

OLAP tools are used to analitical purpose basically for report generation i.e to retrieve the data from dataware OLAP is multidimensional model.

Is this answer useful? Yes | No

August 26, 2009 17:07:51

#10

Amithanbr

Member Since: August 2009 Contribution: 5

RE: what is the difference between etl tool and olap tools

ETL TOOL (eg:Informatica Data stage Abinitio..) is for 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(probably a relational database).

OLAP TOOL (eg: Business objects cognos ..) is used to get the data from the datawarehouse which is also possible using the sql statement..

OLAP comes into picture after ETL developers design the warehouse by using olap tools a business user can generate standard reports

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank