Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between etl tool and olap tools
- 3 Answers
- 10854 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
etl tool means extract,transform and load the data into the
ware house.based on this data by using olap tool we can
generate reports
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
Answer / uzval_vee
hai
In my case ETL tool is used to extract data from diffrent
sources,and make the data consistent and transformed to DWH.
olap tools are nothing but a DWH.
| Is This Answer Correct ? | 1 Yes | 6 No |
in general which algorithms for used?
What are aggregate tables and aggregate fact tables?
How to answer the question how many fakt table in your datawarehouse and what size it have?
Explain the difference between view and materialized view?
Fact table is in normalized or de-normalized form?
What are the data types present in bo? What happens if we implement view in the designer n report?
difference between For each and for all
waht is the advantage of infoset query
Explain differences between star and snowflake schemas?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
what is parallelism?
What is DTM session?
Teradata 
