Explain the difference between etl tool and olap tools?

Submitted by: Administrator
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
Submitted by: Administrator

Read Online ETL (Extract, transform, load) Job Interview Questions And Answers