what is the difference between etl tool and olap tools
Answer Posted / b siva pratap
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 |
Post New Answer View All Answers
What is the purpose of Dataware Control?
What is surrogate key? Explain with examples.
What are the various methods of getting incremental records or delta records from the source systems?
Explain which columns go to the fact table and which columns go the dimension table?
Explain the data type of the surrogate key?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Can you state some of the innovations throughout history?
What is pre-emptive and non-pre-emptive?
Explain multivalued dependency?
What are the different types of fact tables used in data warehousing?
Explain what are the methodologies of data warehousing?
Explain what are components of report studio?
Explain why should you put your data warehouse on a different system than your oltp system?
Can a dimension table contain numeric values?
What are the reasons to use a chameleon method in data warehousing?