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?

866

What is the difference between ods and oltp?

951

Explain difference between view and materialized view?

895

How to design file watch jobs?

930

What is the differences between star and snowflake schemas?

988

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

888

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

870

Explain me what is vldb?

877

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

901

Explain the difference between keylokup and joiner?

846

Explain what are the various reporting tools in the market?

917

Explain what is analytical or analytic mean?

961

Explain how are the dimension tables designed?

987

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

906

What are the various transformation available?

962

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is the very basic difference between data warehouse and operational databases?

894

What is data analysis?

899

Explain conformed fact?

902

What is the difference between mapping parameter & mapping variable in data warehousing?

931

What is data validation strategies for data mart v?

1014

Where we use surrogate key explain with example?

1047

Explain what are the tasks that loadmanger process will do?

863

Explain what are conformed dimensions?

1028

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

904

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

2696

How to generate the cubes in framework manager?

965

Explain what is analytical or analytic mean?

961

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

881

What is metadata in context of a datawarehouse and how it is important?

990

What is the main difference between star and snowflake star schema? Which one is better and why?

978

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