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

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

  1. Pingback: Top Posts WordPress.com

  2. 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.

  3. 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

  4. Pingback: SQL SERVER - Business Intelligence (BI) Basic Terms Explanation Journey to SQL Authority with Pinal Dave

  5. 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

  6. 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

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

  8. 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

  9. 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?

  10. Pingback: SQLAuthority News - Best Downloads on SQLAuthority.com Journey to SQL Authority with Pinal Dave

  11. Pingback: SQL SERVER - Database Interview Questions and Answers Complete List Journey to SQL Authority with Pinal Dave

  12. 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)

  13. 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.

  14. 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?

  15. 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.

  16. 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

  17. 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

  18. 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.

  19. Pingback: SQL SERVER – Weekly Series – Memory Lane – #039 | Journey to SQL Authority with Pinal Dave

  20. Pingback: SQL SERVER – Weekly Series – Memory Lane – #040 | Journey to SQL Authority with Pinal Dave

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s