what is the difference between etl tool and olap tools

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5262


What is a core dimension?

606


Explain the difference between filter and conditin?

562


What is degenerate dimension table?

570


Which component has onread method and what it is used for?

506






What are the different types of schemas used in data warehousing?

518


Explain meta data?

548


What is the difference between mapping parameter & mapping variable in data warehousing?

553


Explain me what is vldb?

519


How can you communicate with web server (apache or iis) from coldfusion?

543


What are the various file formats involved in reportnet?

537


What is a staging area? Do we need it? What is the purpose of a staging area?

550


What is data analysis? Where it will be used?

554


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

540


What does level of granularity of a fact table signify?

622