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

What is an error log table in informatica occurs and how to maintain it in mapping?

965

What is static and local variable?

1035

What is the main difference between schema in rdbms and schemas in datawarehouse?

1093

What is surrogate key? Where we use it explain with example?

931

Explain can a dimension table contains numeric values?

967

What is crass reference table?

1054

What is a fact, dimension, measure?

1208

Explain difference between e-r modeling and dimentional modeling?

985

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

924

Explain the definition of normalized and denormalized view?

903

Explain why fact table is in normal form?

970

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

996

Explain dimensional modelling?

983

What is batch processing?

1031

What is aggregate fact table?

990

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

What is latest version of power center / power mart?

1057

What are the steps involved in designing a fact table?

891

What is real-time datawarehousing?

1021

What are the stages of datawarehousing?

1013

What are partition points?

1073

How many types of facts and what are they?

1018

What is degenerate dimension table?

1001

What is data validation strategies for data mart v?

1092

What is the difference between power center & power mart?

981

What is loop in data warehousing?

1140

How do you create surrogate key using ab initio?

996

What is the difference between star and snowflake schemas?

1213

What is Analysis Services?

2143

What is meant by metadata in context of a data warehouse and how it is important?

1203

What is scd1 , scd2 , scd3?

1081

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