Explain the difference between etl tool and olap tools?
- 1 Answers
- 994 Views
- I also Faced
- E-Mail Answers
Answer / Diwan Singh Kanyal
ETL (Extract, Transform, Load) tools are used for data integration, cleaning, and transformation from various sources to a target database or data warehouse. On the other hand, OLAP (Online Analytical Processing) tools are designed for complex data analysis and reporting by providing multi-dimensional views of data, allowing users to perform operations like drill-down, slice-and-dice, roll-up, and pivot. While ETL tools handle the data preparation process, OLAP tools provide an environment for data analysis.
| Is This Answer Correct ? | 0 Yes | 0 No |
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the main role of FI on business
How to fine tune mappings?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
What is Data Vault???
how do u implement scheduling in Informatica?
What are the modules in Power Mart?
What are snapshots?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
In Which Transformation We Can Use Having Clause In Informatica?
how would u estimate the size of Lookup transform data and index cache?
what is the use of server manager?
Teradata 
