what is the difference between etl tool and olap tools
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 |
Explain hybrid slowly changing dimension?
Where can one get more info about Data Warehousing?
Start a batches with in a batch?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is data stream and data adaopter?
Explain what are the mapping paramaters and maping variables?
What is the difference between star and snowflake schemas?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain piconet?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is the difference between a primary and secondary actor in use case modeling?