Rahiman

• Nov 9th, 2005

 

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

Prakash

• Nov 30th, 2005

 

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

sithu

• Jan 3rd, 2006

 

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

sithusithu

 Profile Answers by sithusithu 

• Jan 10th, 2006

 

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

kishore Penchalapadu

• Aug 3rd, 2006

 

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

Shobhit

• Aug 11th, 2006

 

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

Laxman

• Aug 15th, 2006

 

Hello Situ,

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

rajkumar

• Oct 10th, 2006

 

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.

Sujatars

 Profile Answers by Sujatars 

• Jun 16th, 2007

 

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.

Amithanbr

 Profile Answers by Amithanbr Questions by Amithanbr

• Aug 26th, 2009

 

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