Data Warehouse General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Data Warehouse General Interview Questions

Questions Answers Views Company eMail

Explain why should you put your data warehouse on a different system than your oltp system?

989

What is the difference between ods and oltp?

1079

Explain difference between view and materialized view?

1021

How to design file watch jobs?

1020

What is the differences between star and snowflake schemas?

1116

What are the various methods of getting incremental records or delta records from the source systems?

996

Explain which columns go to the fact table and which columns go the dimension table?

968

Explain me what is vldb?

982

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1009

Explain the difference between keylokup and joiner?

937

Explain what are the various reporting tools in the market?

1022

Explain what is analytical or analytic mean?

1055

Explain how are the dimension tables designed?

1110

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

997

What are the various transformation available?

1059

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What are the steps involved in designing a fact table?

934

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1144

What is index awareness in universe?

1088

what are the other factors of the database on which the loading performance depend?

1957

Explain hybrid slowly changing dimension?

1062

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?

1088

What is the main difference between inmon and kimball philosophies of data warehousing?

1148

Explain what is partitioning? What are the types of partitioning?

1012

Explain what are the different types of join operations?

1018

Can we have multiple application.cfm file in an application?

1000

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

997

What is scd1 , scd2 , scd3?

1139

What is surrogate key? Explain with examples.

1222

Explain about core dimension,

1036

Explain how to generate iqd file from framework manager?

996

For More Un-Answered { Data Warehouse General } Questions Click Here