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
What is index awareness in universe?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is meta data and system catalog?
What are the different types of scd's used in data warehousing?
Describe the differences between a data warehouse and data mart.
Explain what are slowly changing dimensions?
Explain what are the tasks that loadmanger process will do?
What is the advantages data mining over traditional approaches?
What is vdl (view definition language) explain?
Do you view contain data?
What do you mean by static and local variable?
What should I have in mind when building olap solution from scratch?
What are cluster analysis in data warehousing?
Explain what is ods (operation data source)?
Explain how to export mappings to the production environment?