You are not logged in.

#1 2012-03-28 05:20:06

AgentVinod12
User RankUser RankUser RankUser RankUser RankUser Rank
Agent Vinod
From: India
Registered: 2012-03-23
Posts: 1,149
Website

Basics Data Warehouse Interview Questions And Answers

Data Warehouse :: Data Warehousing Basics Job Interview Questions and Answers

Basics Data Warehouse guideline for job interview preparation. Explore list of Data Warehousing Basics frequently asked questions(FAQs) asked in number of Basics Data Warehouse interviews. Post your comments as your suggestions, questions and answers on any Data Warehousing Basics Interview Question or answer. Ask Data Warehousing Basics Question, your question will be answered by our fellow friends.

1 Explain Differences between star and snowflake schemas?
2 Explain the data type of the surrogate key?
3 What is a CUBE in datawarehousing concept?
4 Explain Why fact table is in normal form?
5 Explain What are the possible data marts in Retail sales?
6 Explain degenerate dimension table?
7 Explain hybrid slowly changing dimension?
8 Explain conformed fact?
9 Explain BUS Schema?
10 Explain What are the advantages data mining over traditional approaches?
11 Explain Difference between E-R Modeling and Dimentional Modeling?
12 What is a Fact, Dimension, Measure?
13 What is Data warehosuing Hierarchy?
14 Explain What are the steps to build the data warehouse?
15 Explain ER Diagram?
16 what is junk dimension?what is the difference between junk dimension and degenerated dimension?
17 Explain What are the different types of data warehousing?
18 Explain Dimensional Modelling?
19 Explain can a dimension table contains numeric values?
20 Explain the difference between view and materialized view?
21 Explain VLDB?
22 Explain the data types present in bo n wht happens if we implement view in the designer n report?
23 Explain What are the methodologies of Data Warehousing?
24 Explain Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
25 Explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
26 Explain What is the main difference between Inmon and Kimball philosophies of data warehousing?
27 Explain a linked cube?
28 What is the main difference between schema in RDBMS and schemas in DataWarehouse?
29 What is static and local variable?
30 What is metadata in context of a Datawarehouse and how it is important?
31 Suggest a good author for Hyperion in data warehousing?
32 What is incremintal loading?What is batch processing?What is crass reference table?What is aggregate fact table?
33 What is the datatype of the surrogate key?
34 What is surrogate key? where we use it explain with example?
35 Explain the definition of normalized and denormalized view and what are the differences between them?
36 Explain What are the vaious ETL tools in the Market?
37 What are the Data Marts?

2012-03-28 05:20:06

Advertisement
Ads By Google

Re: Basics Data Warehouse Interview Questions And Answers



The following user say "Thank You" for this post:Guest

Board footer