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?

1034

what do you mean by custom groups?

985

what do you mean by kimball?

1002

Explain the difference between holap and molap?

1053

Explain fact relation?

1013

Explain security filter?

1033

How do you optimize reports in microstartegy?

1109

Explain transformations?

1008

How would you configure wh authentication? Explain.

997

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

930

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.

1021

Is there a difference between view filter and report filter?

920

Explain compound key?

983

Explain standard filters?

1005

Explain two-tier connection?

943

Un-Answered Questions { Data Warehouse }

What is the effect of dls on microstrategy?

1005

What are report caches and how many types are there?

972

Hi friends, what are the new features in abinito3.0?

2804

Tell e how how dealt with..

2226

What is the difference between informatica and datastage?

1227

Explain multivalued dependency?

991

What are the advantages of query studio compared to report studio?

893

Can microstrategy desktop access sap data?

948

What is the difference between server job and parallel jobs?

1154

What are the components of the workflow manager?

1135

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186

What is the difference between a data mart and a data warehouse?

1044

how do you test for missing values? : Sas programming

1053

How can we determine what records to extract?

1081

What is the difference between %put and symbolgen? : sas-macro

1238

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