What do you understand about the concept of Data Warehousing? – InterviewSolution

InterviewSolution

1.	What do you understand about the concept of Data Warehousing?
Answer» Data warehousing is the PROCESS of collecting, extracting, processing, and importing data from numerous sources and storing it in a single database. A data warehouse can be thought of as a central repository for data analytics that receives data from transactional systems and other relational databases. A data warehouse is a collection of historical data from an organization that AIDS in decision making. The data from a data warehouse is further USED for Data visualization, REPORTING, BUSINESS intelligence and many more activities.

Discussion

No Comment Found

Related InterviewSolutions

State your understanding of Pure Object Oriented Programming Languages. Is Java one? If not, then why?
State the pros and cons of using Object Oriented Programming Languages.
State a few benefits of using C ++ as a language.
Define Subqueries in SQL. Given a table of employees, write down a SQL query using subqueries to find all the employees with salaries greater than five thousand.
What do you understand about transactions in SQL? What are the properties of transactions in SQL?
Define Index Hunting. What is it used for in Database Management Systems?
What is meant by Intension and Extension in Database Management Systems?
What is meant by Proactive Updates, Retroactive Updates and Simultaneous Update in Database Management Systems?
State the various levels of data abstraction in Database Management Systems.
Define the terms: Aggregation and Atomicity in Database Management Systems.