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 what is fact less fact table? Where you have used it in your project?

933

What does level of granularity of a fact table signify?

1095

What are the different methods of loading dimension tables?

993

Explain what are the modules in power mart?

1051

Explain what is ods (operation data source)?

990

Explain difference between data ware house & data mart?

990

Explain what is the difference between view filter and report filter?

978

What is data type of the surrogate key?

1001

Where the applications and where ware house management system is used?

1015

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

923

What is the difference between power center & power mart?

981

Explain what are conformed dimensions?

1089

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

962

How to calculate fact table granularity?

1020

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Explain some of modeling tools available in the market?

968

Explain what is the difference between powerplay transformer and power play reports?

1159

How to get the first 100 rows from the flat file into the target?

1210

Explain what is the difference between view filter and report filter?

978

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

1070

What is the difference between dependent data warehouse and independent data warehouse?

1007

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

1131

What are the tools available for etl?

972

What are aggregate transformation?

1037

What is the main difference between inmon and kimball philosophies of data warehousing?

1116

What is VLDB?

1056

What are the stages of datawarehousing?

1013

Explain dimension table ?

983

What are the different types of datawarehosuing?

991

What are the methodologies of data warehousing?

992

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