What are the applications of data warehouse? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

27. What are the applications of data warehouse? - ETL

Datawarehouse are used extensively in banking and financial services, consumer goods.
Datawarehouse is mainly used for generating reports and answering predefined queries.
Datawarehouse is used for strategic purposes, performing multidimensional analysis.
Datawarehouse is used for knowledge discovery and strategic decision making using data mining tools.

(Continued on next question...)

Other Interview Questions

• What is a Repository? - ETL
• What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
• In Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how do I do this? - ETL
• ETL or Data warehouse testing is categorized into four different engagements irrespective of technology or ETL tools used:
• What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL
• What is Data warehouse - ETL?
• What are the types of Facts? - ETL
• What does the Bottom Up Approach or Ralph Kimball Approach says? - ETL
• What is a Work Flow? - ETL
• What is Full load & Incremental or Refresh load?
• More...