Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10700 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 |
How to export mappings to the production environment?
what is the difference between DSS and ODS ?
What are components of report studio?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are different stages of ?Data mining??
Where the cache files stored?
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.
What is drilling across?
What are the different types of segments?
Where can one get more info about Data Warehousing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is the differences between star and snowflake schemas?
Teradata 
