Data Warehousing basic questions

What is Data Warehousing?

A data warehouse can be considered as a storage area where interest specific or relevant data is stored irrespective of the source. What actually is required to create a data warehouse can be............
Read answer

What is Virtual Data Warehousing?

A virtual data warehouse provides a collective view of the completed data. A virtual data warehouse has...........
Read answer

Explain in brief various fundamental stages of Data Warehousing.

Stages of a data warehouse helps to find and understand how the data in the warehouse changes. At an initial stage of data warehousing data of the transactions is merely copied to another server. Here, even if the copied data is processed for reporting, the source data’s performance won’t be affected..............
Read answer

What is active data warehousing?

An active data warehouse represents a single state of the business. Active data warehousing considers the analytic perspectives of customers................
Read answer

What is data modeling and data mining? What is this used for?

Data Modeling is a technique used to define and analyze the requirements of data that supports organization’s business process. In simple terms, it is used for the analysis of data objects in order to...........
Read answer

Difference between ER Modeling and Dimensional Modeling

The entity-relationship model is a method used to represent the logical flow of entities/objects graphically that in turn create a database. It has both logical and physical model. And it is good for reporting and point queries..............
Read answer

What is the difference between data warehousing and business intelligence?

Data warehousing relates to all aspects of data management starting from the development, implementation and operation of the data sets. It is a back up of all data relevant to business context i.e. a way of storing data.............
Read answer

Describe dimensional Modeling.

Dimensional model is a method in which the data is stored in two types of tables namely facts table and dimension table. Fact table comprises of information to measure business successes and the............
Read answer

What is snapshot with reference to data warehouse?  

Snapshot refers to a complete visualization of data at the time of extraction. It occupies less space and can be used to back up and restore data quickly...............
Read answer