Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10756 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 |
I have two universes created by two difference database can we join them in designer & report level? How
What is scd1 , scd2 , scd3?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Why should you put your data warehouse on a different system than your oltp system?
What is called dimensional modelling?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
What are modeling tools available in the market?
What is conformed dimension?
What are vaious etl tools in the market?
What is the goal of optimizer?
What are algorithms provided by Microsoft in SQL Server?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Teradata 
