State difference between ETL and OLAP (Online Analytical Processing) t

1.	State difference between ETL and OLAP (Online Analytical Processing) tools.
Answer» ETL tools: The DATA is extracted, transformed, and loaded into the data warehouse or data mart using ETL tools. Several transformations are necessary before data is loaded into the target table in ORDER to implement business logic. Example: Data stage, Informatica, etc. OLAP (Online Analytical Processing) tools: OLAP tools are designed to create reports from data warehouses and data marts for business ANALYSIS. It loads data from the target tables into the OLAP repository and performs the required MODIFICATIONS to create a report. Example: Business OBJECTS, Cognos etc.

Discussion