what is the difference between etl tool and olap tools
- 3 Answers
- 9746 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
How to generate the cubes in framework manager?
Explain ddl (data definition language)?
How to eliminate duplicate rows from flat file?
How to load the time dimension?
What is surrogate key? Where we use it?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Is there any rownum object from which we can do this?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What are snapshots? What are materialized views & where do we use them?
Compare and contrast aggregates & indexes
How to add a number to a macro variable?
Explain the definition of normalized and denormalized view and what are the differences between them?
How do you define data block size?
What are the advantages of cold fusion?
What is the difference between view filter and report filter?
