Oracle Extract transform load (ETL) Question:
Download Questions PDF

What is the difference between etl tool and olap tools?

Answer:

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

Download Oracle ETL Interview Questions And Answers PDF

Previous QuestionNext Question
What is ODS (operation data source)?What is the metadata extension?