ETL is a extraction transformation loading tool i.e u can extract u can transform using different transformations available in tool and aggreagte the data. The output of this ETL tool is used as input to OLAP tool

OLAP is online analytical process where u can get online reports after doing some joines creating some cubes

ETL tools in market

1 INFORMATICA-- univeral tool good market

2 ABINITO -- fastest loading tool very good market

3 DATASTAGE-- difficult work no good market

4 BODI-- good market

5 ORACLE WAREHOUSE BUILDER-- good market

ETL is 2 step before OLAP

1) Sources (source of data they can b different data bases)

2) ETL (u extractl transforms and load the data )

3) Data stagging or busines subjective( then u store and stag the data)

4) OLAP (through olap u visualize different data differently)

Yes OLAP is after ETL. Its how user's querry the data that the ETL loaded to do analytical work; Sales Analysis for example.

OLAP Vendors: Microstrategy BO (IE: Crystal) Hyperion...