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?

985

what do you mean by custom groups?

936

what do you mean by kimball?

939

Explain the difference between holap and molap?

1007

Explain fact relation?

943

Explain security filter?

953

How do you optimize reports in microstartegy?

1055

Explain transformations?

970

How would you configure wh authentication? Explain.

934

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

886

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.

972

Is there a difference between view filter and report filter?

885

Explain compound key?

931

Explain standard filters?

953

Explain two-tier connection?

905

Un-Answered Questions { Data Warehouse }

What is enterprise data warehousing?

1000

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4154

What do you mean by consolidations?

977

how to connect datamarts

2747

What is meant by target load plan?

929

What are the other names given to data warehousing?

1060

How do you see a ddl for an existing table?

975

What is a compound attribute in microstrategy?

995

Which are the different editions of informatica powercenter that are available?

990

What are the different components of powercenter?

1005

How can we schedule the graph in unix?

951

What is index awareness in universe?

975

What is informatica metadata and where is it stored?

952

How to update a particular record in target with out running whole workflow?

1549

How will the document be delivered to me?

1033

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