A Data warehouse is a depository of integrated information,
available for queries and analysis. It is a logical collection of
information gathered from different operational databases which are used
to create business intelligence that supports business analysis
activities and decision-making tasks. Data warehouses are designed to
facilitate reporting and analysis.
If you are planning to have a career in this field then you should mentally prepare yourself to answer some of the frequently asked questions which are listed as under:
1. What is ODS?
Operational database Store (ODS) is a collection of operation or bases data that is extracted from operation databases. It is used to support data mining of operational data.
2. In which situation do we use update strategy?
Update strategy is used to update some existing value in a database. For this you need a primary key in the target.
3. What is a lookup table?
A lookup table is a table which is used for updating a warehouse. When the lookup is placed on the target table (warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition.
4. Tell me about your skills?
I have strong data modeling, communicational, interpersonal, business, problem solving and professional consulting skills. I also have ample knowledge of data warehouse market, vendors, and standard bodies.
5. What is the difference between OLAP and OLTP?
OLAP stands for online analytical processing and OLTP stands for online transaction processing. OLAP support historical data but OLTP does not support historical data. In OLAP, data is stored for analysis or some comparison for the development of business or to know where they stand whereas OLTP databases are fully normalized and are designed to consistently store operational data.
6. How do you handle stress and pressure?
You can answer this question by saying that, I like to work in difficult and challenging environment and I give better result while working under pressure and stress. I enjoy challenges and deadlines because I diffuse the stress.
7. Would you like to ask any question?
You should prepare question in advance for the interviewer such as the growth scope, your project etc. It gives a good impression as it shows that you are eager to work with that company.
The above listed question will be a great help to those who want to apply for the job of Data warehousing.
If you are planning to have a career in this field then you should mentally prepare yourself to answer some of the frequently asked questions which are listed as under:
1. What is ODS?
Operational database Store (ODS) is a collection of operation or bases data that is extracted from operation databases. It is used to support data mining of operational data.
2. In which situation do we use update strategy?
Update strategy is used to update some existing value in a database. For this you need a primary key in the target.
3. What is a lookup table?
A lookup table is a table which is used for updating a warehouse. When the lookup is placed on the target table (warehouse) based upon the primary key of the target, it just updates the table by allowing only new records or updated records based on the lookup condition.
4. Tell me about your skills?
I have strong data modeling, communicational, interpersonal, business, problem solving and professional consulting skills. I also have ample knowledge of data warehouse market, vendors, and standard bodies.
5. What is the difference between OLAP and OLTP?
OLAP stands for online analytical processing and OLTP stands for online transaction processing. OLAP support historical data but OLTP does not support historical data. In OLAP, data is stored for analysis or some comparison for the development of business or to know where they stand whereas OLTP databases are fully normalized and are designed to consistently store operational data.
6. How do you handle stress and pressure?
You can answer this question by saying that, I like to work in difficult and challenging environment and I give better result while working under pressure and stress. I enjoy challenges and deadlines because I diffuse the stress.
7. Would you like to ask any question?
You should prepare question in advance for the interviewer such as the growth scope, your project etc. It gives a good impression as it shows that you are eager to work with that company.
The above listed question will be a great help to those who want to apply for the job of Data warehousing.
No comments:
Post a Comment