what is the difference between etl tool and olap tools
- 3 Answers
- 9745 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
etl tool means extract,transform and load the data into the
ware house.based on this data by using olap tool we can
generate reports
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / harshad
ETL Tool is used to Extrand Transform and Load data into
your Dataware house e.g. Informatica. OLAP Tool is nothing
but to design your Dataware house (more in logical) e.g.
Oracle Warehouse builder (can be use for ETL) or Siebel
Analytics (more for Dahsboard purpose but you can design
your DW)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / uzval_vee
hai
In my case ETL tool is used to extract data from diffrent
sources,and make the data consistent and transformed to DWH.
olap tools are nothing but a DWH.
| Is This Answer Correct ? | 1 Yes | 6 No |
What is a data profile?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Advantages of de normalized data?
Can you state some of the innovations throughout history?
How to generate iqd file from framework manager?
Explain about core dimension,
Explain when do we analyze the tables? How do we do it?
What is a core dimension?
Explain what is the extension of file to save template?
What are components of reportnet?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is a functional dependency f said to be minimal?
Teradata 
