Answer Detail: RE: what is the difference between etl tool and olap t...

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: what is the difference between etl tool and olap tools

November 11, 2005 02:20:27	#1
Rahiman	Member Since: Visitor Total Comments: N/A
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