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

Your application mode has crashed. How would you get the instance back?

1006

What do you mean by mstr?

1158

What do you mean by bulk export report?

989

What do you mean by xml cache?

1023

Is it possible to get a floating window in microstartegy web? If yes, how?

1213

Explain fact structure?

1029

What are the different types of mstr objects?

1051

How will you monitor the errors received while running i-server and report?

992

Can you explain surrogate key?

1104

Your application mode has crashed. How would you run your i-server?

1051

What is an i-server? What are the different modes to run it?

1025

How would you increase the logical size of a table in microstrategy?

1026

According to you, what are the most important tables in a dw? Why?

1035

Explain scan md?

1142

Explain fact constellation schema?

1089

Un-Answered Questions { Data Warehouse }

Explain what are the mapping paramaters and maping variables?

1147

List out all forms of LOCKS that are available in Teradata.

1011

What is an enterprise?

1112

How to join three sources using joiner?

1201

Where do we use mapping variables in informatica?

1124

What kind of layouts does abinitio support?

1371

what is the main role of FI on business

2157

What is meant by incremental aggregation?

1187

When can we choose the Redshift ?

what are the types of interactive display types? : Sas-bi

1151

What are the default statistics that proc means produce?

1092

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2060

What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4447

what do you mean by security filter?

1065

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2153

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