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?

983

What does level of granularity of a fact table signify?

1151

What are the different methods of loading dimension tables?

1042

Explain what are the modules in power mart?

1094

Explain what is ods (operation data source)?

1033

Explain difference between data ware house & data mart?

1031

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

1035

What is data type of the surrogate key?

1054

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

1056

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?

978

What is the difference between power center & power mart?

1031

Explain what are conformed dimensions?

1145

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

997

How to calculate fact table granularity?

1071

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?

1111

Post New Data Warehouse General Questions

Un-Answered Questions { Data Warehouse General }

Briefly state different between data ware house & data mart?

1085

Can you state some of the innovations throughout history?

1028

What are the other names given to data warehousing?

1149

What is surrogate key? Explain with examples.

1221

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

1054

How to define a cube??

992

What are non-additive facts in detail?

1054

The same tier?

1141

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

1016

How can you import tables from a database?

1154

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

1055

What is factless fact tables?

1286

In document how to create metrics?

1045

Explain multivalued dependency?

1041

How do you create surrogate key using ab initio?

1049

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