FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

Informatica INTERVIEW QUESTION & ANSWERS

Data Warehousing
Follow Us
 
TAGS
1. 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.
  Posted by Krishna Velpula (Jun 06, 2014)
 

A DWH is a RDBMS which is especially designed for analysis of the business and decisons making to achive the business goals but not for the business transformation.
  Posted by Uttam. (Feb 21, 2014)
 

A single, complete and consistent store of data obtained from a variety of different sources made available to end users in a what they can understand and use in a business context.
  Posted by Bijaya Kumar Jena. (Jan 28, 2014)
 

A Data ware house is a relational Database Management System which is specifically design for Business analysis and making decisions to achieve the business goal.

A data ware house is design to support decision system(dss). It is also called historical database. Because it will keep all the historical information. It is also called as Read only database system.

A data ware house is a integrated database which stores the data in integrated format.

Characteristics of data ware house: Time variant Non volatile Subject oriented Integrated
Your Name Your Email-ID
Your Answer
 
2. 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.
  Posted by Harikumar (Jun 13, 2014)
 

In Data base we can maintain only current data which was not more than 3 years But in datawarehouse we can maintain history data it means from the starting day of enterprise DDL commands it means ( Insert ,update,delete)we can do in Database In datawarehouse once data loaded in Datawarehouse we can do any DDL operatations

  Posted by Vairamuthu M. (Jan 03, 2014)
 

Easy to write

Your Name Your Email-ID
Your Answer
 
3. 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.
Your Name Your Email-ID
Your Answer
 
4. What are the types of data warehouse?
 
    There are mainly three type of Data Warehouse are :
  • Enterprise Data Warehouse
  • Operational data store
  • Data Mart
Your Name Your Email-ID
Your Answer
 
5. 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.
  Posted by Sudhansu Nayak (Jun 18, 2014)
 

Data warehouse is the base for Data Mining. Data Mining basically extract the knowledge from Data warehouse. It means by analyzing data in data warehouse, will predict trend in business.
Your Name Your Email-ID
Your Answer