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 Active Datawarehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain the different types of data warehousing?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What needs to be done while starting the database?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain what are necessary tasks to install reportnet software?
Name a few sectors which use data warehousing?
Explain me what are data marts?
Can we take backup when the database is opened?
How did you plan your Data ware house project?
What is load manager?
What are components of reportnet?
What is data stream and data adaopter. Is it same are different? Explain?