DATA WAREHOUSE INTERVIEW QUESTIONS ANSWERS FOR EXPERIENCED
DATA WAREHOUSE INTERVIEW QUESTIONS WITH ANSWRES FOR DBA Here are most FAQ for Database developer/DBA both for fresher and experienced. So...
Here are most FAQ for Database developer/DBA both for fresher and experienced. So lets start.
Q):- Who is recognized as the father of the data warehouse ?
Ans:- William H. Inmon (born 1945)
Q):-What is Data Warehouse?
Ans:- A data warehouse is nothing but a relational database that is designed for query and analysis/research purpose rather than for normal transaction purpose. The idea behind data warehouse is to store large amount of data which help us to make business intelligence decisions.
Q):-How data warehouse help us to take business intelligence decisions, any example ?
Ans:- For example.
We will be looking at data warehouse to provide us answers as how much money a particular zipcode make(if we sell products in large scale),what the average ages for medium level of education. In those type of things data warehouse help us.
Q):-How does you compare online transaction process(normal database designed for transactional process) and data warehouse performance wise, means for which performance matter much?
Ans:- Performance is not that critical in a data warehousing solution but in online transactional processing environment performance will be very critical because those systems your customer on the other end want to place order right now, in data warehouse solution you can write very large queries producing report sending to those management, so you don't necessarily have somebody on the other hand requesting information right now.
Q):-What is Data Mart(DM) in data warehouse environment?
Ans:- A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team.
Q):-What is a Fact table?
Ans:- Fact table is a table containing measurements(mostly numeric data, ex. grade).
Q):-What is a Dimension table?
Ans:- Dimension table is a table containing business elements.