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)
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
possible to handle DDL statements in replication , if possible means how can we do, plz explain in detail
hello sir
sql srver 2008 material and interview questions send me
Pls spend some money on books and get the books on sql 2008 from book store.
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”