July 29, 2007 by Pinal Dave

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

SQL Server Interview Questions and Answers

Print Book Available (207 Pages) | Sample Chapters

Download Data Warehousing Interview Questions and Answers Complete List

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.

Download Data Warehousing Interview Questions and Answers Complete List

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 (
http://blog.SQLAuthority.com
)

About these ads

56 thoughts on “SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download”

Qumer Mumtaz | July 30, 2007 at 6:30 am

hi
Dave
this is really comprehensive list of FAQs. Thank you for sharing ur knowledge.

Reply
Pingback: Top Posts WordPress.com
Bart Czernicki | July 30, 2007 at 7:57 pm

Very good list of questions for general theory.

However, employers seeking a candidate with a very good understanding of SQL Server Data Warehousing absolutely need to quiz the candidate on: SSIS, SSAS and performance tuning/indexing as well.

Reply
rajesh | August 11, 2007 at 3:36 am

hello dave,
i went thro your article regarding questions and answers in data warehouse. It s really good.

Reply
hitesh | August 14, 2007 at 2:21 am

hi, please send me sql question and answer .i am very thankful to you.

Reply
pankaj | August 29, 2007 at 10:56 pm

this is very good website for improving knowledge.

Reply
sunanda | September 7, 2007 at 2:20 am

Please provide me the SQL Server DWH questions and answers.

Thanks and Regards,
Sunanda Kumar.

Reply
MADHU | September 12, 2007 at 12:46 am

PLEASE PROVIDE DATAWARE HOUSING INTERVIEW QUESTIONS WITH ANSWER

THANKS

Reply
Darshan | October 20, 2007 at 1:59 am

Hello Sir

My name is Darshan.
I would like to know
1) How to get the second maximum value , without using ‘subquery’ ?
2) How to find top 3 Salery/ Or any varing value without using ‘TOP function’?

Thanks and Regards
Darshan

Reply
Pingback: SQL SERVER - Business Intelligence (BI) Basic Terms Explanation Journey to SQL Authority with Pinal Dave
Shareef | November 9, 2007 at 5:08 pm

Hi,
I need FAQ on MS SS Analysis Services and Reporting Services. Cud u pl send it?
thanks,
Shareef

Reply
Deep | November 20, 2007 at 10:33 am

Hi,
Thanks for listing these questions/answers.
Deep

Reply
Dilip | December 5, 2007 at 1:29 pm

Realy fabulous materials…………

Reply
Sandhya | December 19, 2007 at 12:22 pm

please tell me the basics of SQL

Reply
Rajendra Uppal | December 22, 2007 at 7:16 pm

Hi, This is Rajendra, your material is really a lot of help to job seekers….thanks.
~rajendra.

Reply
R B Reddy | January 3, 2008 at 3:08 am

This site is a ” Holly Bible” for Us, Thanks for your Help……..

Reply
Amit | January 3, 2008 at 6:31 pm

Thanx Pinal
its good to crack an interview

##@mit##

Reply
omila | February 12, 2008 at 5:35 pm

Hi
I need to find data warehouses developed for manufacturing organization (Apparel, etc) for decision making.

I just need their business problem, why they selected data warehouse solution.
I search for several days to get this info but i couldn’t.
Its great help if anyone can send any links related to this. Sorry if this is not the correct place to publish this.. I’m really in need for this information.

Thanks in advance.
Omi

Reply
Chandhra | February 19, 2008 at 5:59 pm

Excellent website…………. Thanx a TON……… Dave

Reply
Mickey | February 21, 2008 at 2:48 am

Wonderful information! Thanks!

Reply
Gouse | April 1, 2008 at 8:33 pm

Please send me the sql questions and answers.
Please mail to this id.

Reply
Radhakruhsna | May 5, 2008 at 12:30 pm

This is really good.

Reply
ahamad | May 9, 2008 at 12:46 pm

Hi Friends,

I am ahamad , i am new and i don’t know about knowledge datawarehousing. but i am interest in datawarehouse, at the time market want to which tools and interview calls are coming which moduels.

My friend are said “Microstrategy” is a new at IT industrey. they told me you learn this tools .

so i am confessed which one is better plz tell me , i need your help in my new life.

byeee

Reply
harikishan | July 2, 2008 at 5:02 pm

HI
could anyone plz send the downloadable version of the BI FAQ
Iwould be very thankful
thank you
harikishan

Reply
Shyam | July 31, 2008 at 10:16 am

Hello Pinal,
Can we update Primary key with to restore old record at the same id.
regards
Shyam

Reply
Suresh K V V | August 16, 2008 at 3:07 am

Hi Pinal,

I would be very thankful, if you can please share with us – any Faq’s available on SSAS, SSIS and SSRS in SQL2005.

Regards,
Suresh

Reply
Truster | September 1, 2008 at 3:14 pm

Dave, this is a great post about Data warehousing with your series of questions and answers.

I am currently working on my company’s database and would like to share my experience. I tend to use Open Source programs to manage my database: mainly Pentaho and Talend Open Studio.
I prefer Talend Open Studio as it is user-friendly (I especially like the tmap component in Open Studio), has a good GUI and makes it possible to perform data integration without being an expert.
The tool also has an active community able to help you out. Maybe you should try it?

Reply
praneeth | November 25, 2008 at 12:05 am

thats a great job

Reply
Pingback: SQLAuthority News - Best Downloads on SQLAuthority.com Journey to SQL Authority with Pinal Dave
Pingback: SQL SERVER - Database Interview Questions and Answers Complete List Journey to SQL Authority with Pinal Dave
Akbar | April 17, 2009 at 2:28 pm

Hi.
there is always a question for me.
for example i have a big database like a bank.
how can i manage this database.how can i archive this.
how to sotre these data.how to search any data from this database.and how can i make reports of this database.
is this a right way to sotre all data in a single database and make reports from it.
it may No. it may i must manage data warehause.
please help me and diccuse about this.
thanks more dear friends. (akbar_mansoori2000@yahoo.com)

Reply
Mark | April 29, 2009 at 2:45 pm

Hi Akbar,

What I could propose is to look at some software to work on your database. Sorting, searching or making reports on a database isn’t always very easy and can take some time if the software you use isn’t adapted to large databases.

As Truster writes above, I would advise you using an open source softwre like Talend open studio. It is adapted to large databases and can perform other actions on your database. And it is open source, meaning it is free to download. Its a good data warehousing solution.

Reply
chandu | September 4, 2009 at 7:16 pm

thank you a very good post it helped me a lot

Reply
Tabita | September 29, 2009 at 4:28 pm

Thank you a lot! You are great!

Reply
Raguram | November 13, 2009 at 5:39 pm

Thanks a ton for these comprehensive posts !!

Reply
Raguram | November 13, 2009 at 5:40 pm

I would be immensely grateful to you sir, if you could you post interview questions for Business Intelligence also ? Thanks :)

Reply
job interviews questions and answers | November 16, 2009 at 3:28 am

I have looked at many sites and not previously come across a site such as yours which tells everyone all they need to know.I have added you to my bookmarks. Can anyone suggest other related topics that I can search for to get more information?

Reply
sudhir | December 16, 2009 at 1:23 pm

Thanks alot for ur great work

Reply
Chaitanya Kiran N | February 13, 2010 at 4:59 pm

Hi dev,

can u tell us the flow of the transformations we are having is ssis.

can u please forward the interview question and Answers for ssis and ssrs.

Reply
Vijaya Kadiyala | April 20, 2010 at 9:44 am

Hi Pinal Bahi

thanks buddy for preparing questions…

You may want to include things like

1) Role-Playing Dimension
2) Double-barreled joins
3) First-Level data marts
4) Conformed Facts
5) Multi-Valued dimension
and finally few words about Data Warehouse Bus Matrix.

Thanks — Vijaya kadiyala

Reply
Dinesh | May 12, 2010 at 8:52 am

Good article!
Thanks – Dinesh

Reply
jagadeesh | May 20, 2010 at 11:45 pm

Hi All,

How can we become MVP.

Thanks
Jagadeesh

Reply
shahab | August 17, 2010 at 7:06 am

good stuff… thanks

Reply
Yugandhar | November 9, 2010 at 1:21 pm

Thanks.

Reply
msand | December 31, 2010 at 8:28 pm

Thanks alot!!!
It was useful.

Reply
aravinth pvsa | January 20, 2011 at 7:04 pm

good too good……… thank you boss……….

Reply
fzboy | February 2, 2011 at 11:34 pm

Thanks, good stuff!

Reply
mahesh | February 11, 2011 at 3:42 pm

hi,

Please give latest ssas,ssrs interview questions yar

Regards
mahesh

Reply
Ankur Singh | March 10, 2011 at 2:44 pm

Hi Pinal

I am Ankur Singh,graduate student in SDSU(CA).
I am looking forward to make my career in Database field and preparing for interviews.
Your SQL server and Data Warehouse interview questions and answers helped me alot.
I would appreciate you if I can get SSIS and SSRS interview questions and answers as well so that I can prepare well for interviews.
With Regards

Reply
Feodor | April 27, 2011 at 11:25 am

Thank you so much for this list!

Reply
Pallavi | June 6, 2011 at 5:29 pm

Hi,

Can someone tell me two ways of writing query for create table??

Thanks!

Reply
- madhivanan | June 10, 2011 at 2:28 pm
  
  create table(………)
  
  select * into table from old_table
  
  But the table created from second method will not have indices that old_table has
  
  Reply
amar | April 9, 2012 at 7:58 pm

Hi,
Please give me ssis,ssrs interview quotions..

Reply
Sreehari | June 22, 2012 at 7:07 pm

Hi Pinal,

I have few questions on Data Warehousing as am new to DWH.Following are my questions:

1. What is business key in DWH.
As per i under stood : A PK of a table from which dimension table is loaded. Am I right ? if wrong can u plz explain.
2. What is the relation between fact table and dimension table.
3. what is the relation between factless fact and dimension table.
4. Can you please send me one simple model where it inculdes fact table,factless fact and dimension table.
5. Is factless fact table a bridge table?
6. Why operational reports are generated at the ODS why not at the DWH. What happens if its operational reports are pulled from DWH.

It could be helpfull if you answer my question. Waiting for your reply as early as possible.

Reply
Prameela | July 17, 2012 at 1:27 pm

Hi, I need SSAS,SSRS related topics and FAQs, Please send me…

Reply
Khyati Shah | September 5, 2012 at 11:55 am

Thanks Pinal,
I am your fan. Every time I look up for any SQL related stuff, SQLAuthority comes up first.

Reply

Journey to SQL Authority with Pinal Dave

SQL, SQL Server, MySQL, Big Data and NoSQL

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

56 thoughts on “SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download”

Leave a Reply Cancel reply

Follow “Journey to SQL Authority with Pinal Dave”

Share:

Like this:

56 thoughts on “SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download”

Leave a Reply Cancel reply

Follow “Journey to SQL Authority with Pinal Dave”