Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10553 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 are the various file formats involved in reportnet?
Database in use is oracle?
How to use the tool Ontobulider
What are fundamental stages of data warehousing?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is is a star schema?
Difference between ODS and Staging
What is MODEL is Data mining world?
Explain where do we use semi and non additive facts?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain can report net connect multiple datasource at a time in report creation time?
What are the different types of data warehousing?
Teradata 
