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?

983

what do you mean by kimball?

1000

Explain the difference between holap and molap?

1051

Explain fact relation?

1011

Explain security filter?

1022

How do you optimize reports in microstartegy?

1109

Explain transformations?

1007

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?

981

Explain standard filters?

1003

Explain two-tier connection?

942

Un-Answered Questions { Data Warehouse }

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2439

What is the difference between global temporary tables and volatile temporary tables?

1181

How can we create index after completion of load process?

1125

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

Explain vproc in teradata?

1000

What is meta data and system catalog?

2300

What is dynamic cache?

1032

What is difference between query studio and report studio?

1088

Explain the difference between detect alias and detect context?

1102

What are the design methods of data warehousing?

948

How many input parameters can exist in an unconnected lookup?

1545

What is proc sort?

1217

Describe the main features of datastage?

1076

update strategy transformation in informatica

1064

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