What is Data warehouse?
In 1980, Bill Inmon known as father of data warehousing. "A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management's decision making process".
Subject oriented : means that the data addresses a specific subject such as sales, inventory etc.
Integrated : means that the data is obtained from a variety of sources.
Time variant : implies that the data is stored in such a way that when some data is changed.
Non volatile : implies that data is never removed. i.e., historical data is also kept.
What is the difference between database and data warehouse?
A database is a collection of related data.
A data warehouse is also a collection of information as well as a supporting system.
What are the benefits of data warehousing?
Historical information for comparative and competitive analysis.
Enhanced data quality and completeness.
Supplementing disaster recovery plans with another data back up source.
What are the types of data warehouse?
There are mainly three type of Data Warehouse are :
Enterprise Data Warehouse
Operational data store
Data Mart
What is the difference between data mining and data warehousing?
Data mining, the operational data is analyzed using statistical techniques and clustering techniques to find the hidden patterns and trends. So, the data mines do some kind of summarization of the data and can be used by data warehouses for faster analytical processing for business intelligence.
Data warehouse may make use of a data mine for analytical processing of the data in a faster way.
What are the applications of data warehouse?
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.
What are the types of datawarehouse applications?
Info processing
Analytical processing
Data mining
What is metadata?
Metadata is defined as the data about data. Metadata describes the entity and attributes description.
What are the benefits of Datawarehousing?
The implementation of a data warehouse can provide many benefits to an organization. A data warehouse can :
Facilitate integration in an environment characterized by un–integrated applications.
Integrate enterprise data across a variety of functions.
Integrate external as well as internal data.
Support strategic and long–term business planning.
Support day–to–day tactical decisions.
Enable insight into business trends and business opportunities.
Organize and store historical data needed for analysis.
Make available historical data, extending over many years, which enables trend analysis.
Provide more accurate and complete information.
Improve knowledge about the business.
Enable cost–effective decision making.
Enable organizations to understand their customers, and their needs, as well competitors.
Enhance customer servicc and satisfaction.
Provide competitive advantage.
Provide easy access for end–users.
Provide timely access to corporate information.
What is the difference between dimensional table and fact table?
A dimension table consists of tuples of attributes of the dimension. A fact table can be thought of as having tuples, one per a recorded fact. This fact contains some measured or observed variables and identifies them with pointers to dimension tables.
Post Your Answers
In 1980, Bill Inmon known as father of data warehousing. "A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management's decision making process".
Subject oriented : means that the data addresses a specific subject such as sales, inventory etc.
Integrated : means that the data is obtained from a variety of sources.
Time variant : implies that the data is stored in such a way that when some data is changed.
Non volatile : implies that data is never removed. i.e., historical data is also kept.
What is the difference between database and data warehouse?
A database is a collection of related data.
A data warehouse is also a collection of information as well as a supporting system.
What are the benefits of data warehousing?
Historical information for comparative and competitive analysis.
Enhanced data quality and completeness.
Supplementing disaster recovery plans with another data back up source.
What are the types of data warehouse?
There are mainly three type of Data Warehouse are :
Enterprise Data Warehouse
Operational data store
Data Mart
What is the difference between data mining and data warehousing?
Data mining, the operational data is analyzed using statistical techniques and clustering techniques to find the hidden patterns and trends. So, the data mines do some kind of summarization of the data and can be used by data warehouses for faster analytical processing for business intelligence.
Data warehouse may make use of a data mine for analytical processing of the data in a faster way.
What are the applications of data warehouse?
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.
What are the types of datawarehouse applications?
Info processing
Analytical processing
Data mining
What is metadata?
Metadata is defined as the data about data. Metadata describes the entity and attributes description.
What are the benefits of Datawarehousing?
The implementation of a data warehouse can provide many benefits to an organization. A data warehouse can :
Facilitate integration in an environment characterized by un–integrated applications.
Integrate enterprise data across a variety of functions.
Integrate external as well as internal data.
Support strategic and long–term business planning.
Support day–to–day tactical decisions.
Enable insight into business trends and business opportunities.
Organize and store historical data needed for analysis.
Make available historical data, extending over many years, which enables trend analysis.
Provide more accurate and complete information.
Improve knowledge about the business.
Enable cost–effective decision making.
Enable organizations to understand their customers, and their needs, as well competitors.
Enhance customer servicc and satisfaction.
Provide competitive advantage.
Provide easy access for end–users.
Provide timely access to corporate information.
What is the difference between dimensional table and fact table?
A dimension table consists of tuples of attributes of the dimension. A fact table can be thought of as having tuples, one per a recorded fact. This fact contains some measured or observed variables and identifies them with pointers to dimension tables.
Post Your Answers
Thnks to share this
ReplyDelete
DeletePlease Add more questions
ReplyDeleteData Warehousing - 2547 Data Warehousing interview questions and 7191 answers by expert members with experience in Data Warehousing subject. Discuss each question. survival warehouse location
ReplyDelete