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 system call error?

1065

what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?

997

You have got the requirement from a client. Explain the technical approach you will take now.

1036

Explain about compound key?

1149

Explain clustering?

1033

Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

950

Explain security role?

1000

Explain attribute role?

1156

Compare dataset and fileset?

1099

What are objects?

1060

Explain 4gt switch. Does it have any drawback?

1021

Explain confirmed dimensions. When are they used?

1023

Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?

1082

What is the effect of dls on microstrategy?

1061

What do you mean by staging area?

1055

Un-Answered Questions { Data Warehouse }

what is the use of server?

2262

What are the key benefits of ETL Testing?

1102

What is the use of target designer?

1123

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1091

Please explain the different stages in creating a report in cognos report net?

1060

Explain vproc in teradata?

1051

What is data stream and data adapter is it same are different? Explain?

1033

where to use sas business intelligence? : Sas-bi

1168

How to generate cubes in cognos?

1022

define data tab?

What are the types of schemas we have in data warehouse.

1008

how does sas handle missing values in formats? : Sas programming

1195

What are the statements that are executed only?

1216

Can you suggest us materials for sdtm mapping?

4496

What is bi?

1185

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