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 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.
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.
I guess these interview questions would be useful for my informatica preparation also. Thanks for sharing.
ReplyDeleteInformatica institutes in Chennai
Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
ReplyDeleteRegards,
Informatica training center in Chennai
Thanks for sharing this niche useful informative post to our knowledge, Actually SAP is ERP software that can be used in many companies for their day to day business activities it has great scope in future.
ReplyDeleteRegards,
SAP course in chennai|SAP training|SAP Institutes in Chennai|SAP Training Chennai
Cloud is one of the tremendous technology that any company in this world would rely on(Salesforce Certification). Using this technology many tough tasks can be accomplished easily in no time. Your content are also explaining the same(Salesforce crm training in chennai). Thanks for sharing this in here. You are running a great blog, keep up this good work(hadoop training).
ReplyDeleteContact us to hire our offerings like service web design, apps, IOS, Call center software.....
ReplyDeleteThanks for sharing the information.Informatica is a data integration/ETL tool that provides functionality for data transformation and loading of data. Informatica gets data from various sources and it loads the data into different targets. Informatica does not store, it just moves data from one place to another.
ReplyDeleteInformatica training in Chennai
Informatica is one of the most trusted and effective ETL software which is known globally. Informatica is one data warehousing ETL tool. Informatica ha very go opportuities for job across the world.
ReplyDeleteinformatica training in chennai | informatica training institute in Chennai | informatica classes in Chennai
Informatica provides a data quality services and data integration. It has the capability to fetch the data from different heterogeneous source. Bring your career in Informatica field. It has incredible breadth in future.
ReplyDeleteRegards,
Informatica Training Institute in Chennai | Informatica Training center Chennai
Thanks for updating your useful Blog with smart content..keep sharing your interesting article..
ReplyDeleteSix Sigma Certification Training in Chennai | No.1 Six Sigma Certification Exam Center in Chennai