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

Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?

1 2972

What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 2984

We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?

1 2386

Can you have multiple data sources in OBIEE?

1 2806

Do you know about Initialization Blocks? Can you give me an example where you used them?

1 2551

What is query repository tool?

1 3459

Can you migrate the presentation layer to a different server.

2 3805

How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

1 2551

Why do we have multiple LTS in BMM layer? What is the purpose?

1 3826

How do i disable cache for only 2 particular tables?

1 2788

How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.

1 3481

What is time series wizard? When and how do you use it?

1651

What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

1 2512

How to sort columns in rpd and web?

2 5350

You worked on standalone or integrated system?

1 2989

Un-Answered Questions { Data Warehouse }

In ARRAY processing, what does the DIM function do?

1179

expain about the tune parameters?

2421

What is the difference between absolute filtering and standard filtering?

1053

what is the difference steps for data modeling?

2606

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167

Describe 5 ways to do a “table lookup” in SAS?

1154

what is treatment emergent events and treatment emregent adverse event

2408

Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

2223

do you prefer proc report or proc tabulate? Why? : Sas programming

991

How can you validate all mappings in the repository simultaneously?

1376

Enlist the various types of transformations.

1062

Explain what is the advantages data mining over traditional approaches?

1029

What is staging area referring to?

1133

what is the function of catx syntax? : Sas-administrator

1104

What is ibm datastage flow designer?

1153

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