Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10862 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 table partitioning? How it is useful to warehouse database?
What are the key features of chameleon that separates it from other algorithms?
Explain what are components of report studio?
Define Data Warehousing?
Can any one explain the hierarchies level data warehousing.
What is perform recovery?
5.Explain ODS ?
How does data mining and data warehousing work together?
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are slowly changing dimensions?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Teradata 
