Data Warehouse concepts and Interview questions

Tuesday, September 28, 2010

Data Warehouse concepts and Interview questions

SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download

July 29, 2007 by pinaldave
It was great pleasure to write latest series about Data Warehousing Interview Questions and Answers. Just like always again I received lost of suggestion and follow up questions. I have tried to accommodate all of them in last post in the series. I hope this series is helpful to all candidates who are seeking job as well interviewers. I have combined all the questions and answers in the one PDF which is available to download and refer at convenience.
Posted by at No comments:

Data Wartehouse Concepts and interview questions

http://www.coolinterview.com/type.asp?iType=1

http://www.newinterviewquestions.com/cat/Data-Warehousing-Concepts-interview-questions/
Posted by at No comments:
Posted by at No comments:

Data Warehouse concepts and Interview questions

Hi friends this is very helpfull blog for thje beginers so that u may get more and more number of concepts and interview questions regarding Data Warehouse basics

Several concepts are of particular importance to data warehousing. They are discussed in detail in this section.
Dimensional Data Model: Dimensional data model is commonly used in data warehousing systems. This section describes this modeling technique, and the two common schema types, star schema and snowflake schema.
Slowly Changing Dimension: This is a common issue facing data warehousing practioners. This section explains the problem, and describes the three ways of handling this problem with examples.
Conceptual Data Model: What is a conceptual data model, its features, and an example of this type of data model.
Logical Data Model: What is a logical data model, its features, and an example of this type of data model.
Physical Data Model: What is a physical data model, its features, and an example of this type of data model.
Conceptual, Logical, and Physical Data Model: Different levels of abstraction for a data model. This section compares and constrasts the three different types of data models.
Data Integrity: What is data integrity and how it is enforced in data warehousing.
What is OLAP: Definition of OLAP.
MOLAP, ROLAP, and HOLAP: What are these different types of OLAP technology? This section discusses how they are different from the other, and the advantages and disadvantages of each.
Bill Inmon vs. Ralph Kimball: These two data warehousing heavyweights have a different view of the role between data warehouse and data mart.

Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)