Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10616 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is the data type of the surrogate key?
What are vaious etl tools in the market?
What is the purpose of cluster analysis in data warehousing?
Explain which columns go to the fact table and which columns go the dimension table?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what are non-additive facts?
Explain about core dimension,
Explain what are the mapping paramaters and maping variables?
Where the cache files stored?
Explain what is analytical or analytic mean?
How to import vsam files from source to target. Do we need a special plugin?
Explain multivalued dependency?
Where the applications and where
Explain what is the difference between olap and datawarehosue?
What are necessary tasks to install reportnet software?
