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
Define data warehouse?
What is dimension modeling?
Explain what are non-additive facts in detail?
What is a data warehousing?
What is freehand sql?
What are target types on the server?
What is the advantages data mining over traditional approaches?
Where do we use semi and non additive facts?
Explain what is real time data-warehousing?
What is the difference between filter and lookup transformation?
How to design file watch jobs?
How to eliminate duplicate rows from flat file?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain how to generate iqd file from framework manager?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?