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?

923

What is the difference between ods and oltp?

1013

Explain difference between view and materialized view?

959

How to design file watch jobs?

972

What is the differences between star and snowflake schemas?

1064

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

930

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

927

Explain me what is vldb?

933

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

962

Explain the difference between keylokup and joiner?

891

Explain what are the various reporting tools in the market?

981

Explain what is analytical or analytic mean?

1016

Explain how are the dimension tables designed?

1060

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

958

What are the various transformation available?

1012

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

How to performance tune reports?

1161

Explain degenerate dimension table?

1046

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1130

What is data analytics in simple terms?

1188

Explain what are fact, dimension, and measure?

992

How can we do data cleaning?

1057

What are the different types of fact tables used in data warehousing?

993

Explain in detail abt measure objects? And what is the use of it? How to create it?

1011

Explain what are non-additive facts in detail?

1035

Is there any difference in testing database and data ware housing?

2761

What is the 4 + 1 view model as it relates to system modeling?

1040

How can you communicate with web server (apache or iis) from coldfusion?

1118

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2050

What are data modeling and data mining?

1083

What is critical column?

1182

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