DataWarehousing Interview Questions

Collection of Datawarehousing Interview Question Collection.

These questions are frequently asked in top companies like HP and IBM.

• What do you mean by a lookup table?
• Why should you put your data warehouse on a different system than your OLTP system?
• What are Aggregate tables?
• What do you mean by ODS?
• Explain what is active data warehousing?
• Why do we override the execute method is struts? Plz give me the details?
• Differentiate between Datawarehousing and Business Intelligence?
• Explain what is the difference between OLAP and datawarehosue?
• Define a fact less fact table? where you have used it in your project?
• What do you mean by a dimension table?
• Explain about Dimensional Modelling? Why is it so important?
• Why is Data Modeling Important?
• Explain in brief about data mining?
• What do you mean by ETL?
• Why are OLTP database designs not generally a good idea for a Data Warehouse?
• Explain what do you mean by Fact table?
• What are conformed dimensions?
• Explain about the Different methods of loading Dimension tables?
• What is conformed fact?
• What do you mean by Data Marts?
• What is a level of Granularity of a fact table?
• Explain in detail how are the Dimension tables designed?
• Explain in brief about non-additive facts?
• What type of Indexing mechanism do we need to use for a typical datawarehouse?
• What Snow Flake Schema?
• What do you mean by real time data-warehousing?
• What are slowly changing dimensions?
• What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
• Differences between star and snowflake schema?
• What do you mean by a Star Schema?
• What is a general purpose scheduling tool?
• What do you mean by ER Diagram?
• Which columns go to the fact table and which columns go the dimension table?
• What are modeling tools available in the Market?
• Name some of modeling tools available in the Market?
• How do you load the time dimension?
• Explain the advantages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.
• What is Difference between E-R Modeling and Dimentional Modeling.?
• Why fact table is in normal form?
• What are the advantages data mining over traditional approaches?
• Explain in brief about the various ETL tools in the Market?
• What is a CUBE in datawarehousing concept?
• What is data validation strategies for data mart validation after loading process ?
• what is the datatype of the surrogate key ?
• What is degenerate dimension table?
• What does level of Granularity of a fact table signify?
• What is the Difference between OLTP and OLAP?
• What does SCD1 , SCD2 , SCD3 signify?
• What is Dimensional Modelling?
• What are the methodologies of Data Warehousing.?
• Explain in brief about linked cube?
• What is the main difference between Inmon and Kimball philosophies of data warehousing?
• Explain Data warehousing Hierarchy?
• Differentiate between schema in RDBMS and schema in DataWarehouse.?
• What is hybrid slowly changing dimension?
• What are the different architecture of datawarehouse?
• What are the various ETL tools in the Market?
• Explain VLDB in Data Warehousing?
• What are the steps to build the datawarehouse ?
• What is incremental loading? 2.what is batch processing? 3.what is crass reference table? 4.what is aggregate fact table?
• What is junk dimension? what is the difference between junk dimension and degenerated dimension?
• What are the possible data marts in Retail sales.?
• What is the definition of normalized and de-normalized view and what are the differences between them?
• What is meant by metadata in context of a Datawarehouse and how it is important?
• Explain the main 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?
• What do you mean by VLDB?
• Can a dimension table contains numeric values?
• What is the main difference between view and materialized view?
• What is Entity Relationship Diagram?
• What is aggregate table and aggregate fact table ... any examples of both?
• Why De-normalization is promoted in Universe Designing?
• Differentiate between ODS and OLTP?
• What is the difference between datawarehouse and BI?
• Explain what is a snapshot?
• Differentiate between datawarehouse and BI?
• What are non-additive facts in detail?
• What do you mean by a BUS Schema?
• Explain about Normalization and the various forms - First Normal Form, Second Normal Form , Third Normal Form?

Related Posts