SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction

Click here to get free chapters (PDF) in the mailbox

This series is in response to many of my reader’s continuous request to start Data Warehousing Interview Questions and Answers series. This series is written in the same spirit as previous two series which has received good response.

Samples Question from Interview Questions and Answer Series
What is Data Warehousing?

A data warehouse is the main repository of an organization’s historical data, its corporate memory. It contains the raw material for management’s decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems (Ref:Wikipedia). Data warehousing collection of data designed to support management decision making. Data warehouses contain a wide variety of data that present a coherent picture of business conditions at a single point in time. It is a repository of integrated information, available for queries and analysis.

I will post complete series details here. Please watch this space for additional information.

Complete Series of SQL Server Interview Questions and Answers
SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2
SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download

Additional Series List Available to Download
SQL Server Interview Questions and Answers Complete List Download
SQL SERVER Database Coding Standards and Guidelines Complete List Download

Reference : Pinal Dave (https://blog.sqlauthority.com)

Data Warehousing, Database, DBA, SQL Download, SQL Scripts
Previous Post
SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
Next Post
SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary

Related Posts

7 Comments. Leave new

  • hi

    One help pls with below error my DTS is failing pls help on this .. when manually run the DTS files ftped without any issue
    thourgh job it is failing ( autosys)

    rror: -2147220330 (80040496); Provider Error: 0 (0)

    Error string: CreateProcessTask ‘DTSTask_DTSCreateProcessTask_2’: Process returned code -99, which does not match the specified SuccessReturnCode of 0.

    Error source: Microsoft Data Transformation Services (DTS) Package

    Help file: sqldts80.hlp

    Help context: 4900

    Reply
  • possible to handle DDL statements in replication , if possible means how can we do, plz explain in detail

    Reply
  • hello sir

    sql srver 2008 material and interview questions send me

    Reply
  • The links above are pointing to the wrong source…
    “SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download” is pointing to “sql-server-2008-interview-questions-and-answers-download”

    Reply

Leave a Reply