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?

988

What is the difference between ods and oltp?

1079

Explain difference between view and materialized view?

1020

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?

995

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?

1008

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?

1109

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

996

What are the various transformation available?

1059

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain what are the various file formats involved in reportnet?

1017

Explain the differences between normalizer and normalizer transformation?

1105

What is informatica architecture?

1112

Explain conformed fact?

1034

Explain what are the mapping paramaters and maping variables?

1141

Explain Association algorithm in Data mining?

2352

What is the difference between er modeling and dimensional modeling?

1191

What are Aggregate tables?

1225

What is difference between e-r modeling and dimensional modeling?

971

how much memory space occupied real time project (roughly)?

2284

How to provide security in frame work manager for a query subject?

1012

What is data analytics in simple terms?

1266

What are data modeling and data mining?

1137

Explain about core dimension, balanced dimension, and dirty dimension?

1055

Explain the definition of normalized and denormalized view?

941

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