Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10548 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 many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Ist the schema that a data warehouse system can implements.
How to export mappings to the production environment?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Explain a relation schema and a relation?
What is metadata in context of a datawarehouse and how it is important?
Explain difference between view and materialized view?
Name a few sectors which use data warehousing?
What are various warehousing tools?
What is index awareness in universe?
Why is dimensional normalization not required?
Explain the difference between filter and conditin?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is the difference between Datawarehouse and OLAP?
What is meant by metadata in context of a data warehouse and how it is important?
