6 |
ETLTOOL VS REPORTING TOOL |
|
|
Ans |
ETL TOOL |
REPORTING TOOL |
ETL - Extract, Transform, Load data
|
Reporting :: To generate reports |
| Cleansing data,Validating data,Business Logic on the data |
Convert ETL data into Cubes, Pie charts, graphs etc., |
| Developed by ETL developer |
Developed by Reporting developer .End user access the data in terms of Business reports |
| Tools :: Informatica, Data Stage, Oracle Warehouse etc., |
Tools :: Business Objects, Hyperion, Cognos etc., |
|
|
|
