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?

1019

Explain difference between view and materialized view?

961

How to design file watch jobs?

972

What is the differences between star and snowflake schemas?

1065

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

931

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

928

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?

982

Explain what is analytical or analytic mean?

1017

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 }

What is partitioning? What are the types of partitioning?

1167

What is Analysis Services?

2143

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

1060

What is Discover and Execute in XMLA?

2409

How can you set the session management?

1123

what is an use case?

1031

Explain the definition of normalized and denormalized view and what are the differences between them?

925

What is degenerate dimension table?

1001

What is the difference between junk dimension and degenerated dimension?

1136

What is the purpose of Dataware Control?

1048

How to eliminate duplicate rows from flat file?

940

What is many-to-many dimensional model in datawarehousing ?

936

What does level of granularity of a fact table signify?

1095

What is is a star schema?

1174

How did you plan your Data ware house project?

2306

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