what is the difference between etl tool and olap tools
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
Why denormalization is promoted in universe designing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
How can you communicate with web server (apache or iis) from coldfusion?
What is the difference between metadata and data dictionary?
What is the purpose of Dataware Control?
Explain what are the different methods of loading dimension tables?
What are the difference between snow flake and star schema?
What is the difference between er modeling and dimensional modeling?
How to export mappings to the production environment?
Explain what are the modules in power mart?
What is bi?
How to drill through from a powerplay cube to reportnet?
List any five applications of data warehouse.
What are the different types of schemas used in data warehousing?
Explain the difference between oltp and olap?