Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Explain snowflake schema?

1095

what do you mean by custom groups?

1024

what do you mean by kimball?

1046

Explain the difference between holap and molap?

1110

Explain fact relation?

1081

Explain security filter?

1125

How do you optimize reports in microstartegy?

1165

Explain transformations?

1089

How would you configure wh authentication? Explain.

1075

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

984

Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.

1081

Is there a difference between view filter and report filter?

967

Explain compound key?

1024

Explain standard filters?

1057

Explain two-tier connection?

999

Un-Answered Questions { Data Warehouse }

What are fundamental stages of data warehousing?

1090

What is Index Caches size?

1165

How does microstrategy object manager integrate with the microstrategy product suite security model?

1006

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1732

Can you define set to be cardinality?

1064

What is percent-to-total shortcut metric in microstrategy?

1023

What are the stages in datastage?

1143

You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

984

Name the third party tools that can be used in datastage?

1146

What are different table types used in teradata?

1097

Why need staging area database for dwh?

1127

Can you define dimension?

1138

Explain what is the difference between slice and dice and cross tab report?

1146

What are the modules in Power Mart?

1022

explain about citrix scheduling tool in datastage

2512

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