1.

What Is The Difference Between Etl Tool And Olap Tools ?

Answer»

ETL tool is meant for EXTRACTION data from the legacy systems and load into specified data BASE with some process of cleansing data.
ex: Informatica, data stage ....etc
OLAP is meant for Reporting purpose. in OLAP data available in MULTIDIRECTIONAL MODEL. so that u can write simple query to extract data from the data base.
ex: Business objects, Cognos....etc

ETL tool is meant for extraction data from the legacy systems and load into specified data base with some process of cleansing data.
ex: Informatica, data stage ....etc
OLAP is meant for Reporting purpose. in OLAP data available in Multidirectional model. so that u can write simple query to extract data from the data base.
ex: Business objects, Cognos....etc


Discussion

No Comment Found

Related InterviewSolutions