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
Explain why should you put your data warehouse on a different system than your oltp system?
What is the use of incremental aggregation? Explain me in brief with an example?
Explain the different types of data warehousing?
Could any one explain me how to create cascading prompts?
What is data analysis? Where it will be used?
Explain what is data validation strategies for data mart validation after loading process?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain meta data?
What is factless fact tables?
Explain what are the steps to build the data warehouse?
How to import vsam files from source to target. Do we need a special plugin?
What are the key columns in Fact and dimension tables?
Explain what are components of report studio?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are parallel querys and query hints?