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 58

what is the difference between etl tool and olap tools

Total Answers and Comments: 9

Last Update: June 16, 2007 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

Go To Top