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

Approximately what date is represented by the SAS date value of 730?

1277

How do you control the number of observations and/or variables read or written?

1305

In ARRAY processing, what does the DIM function do?

1232

How would you determine the number of missing or nonmissing values in computations?

1132

explain the environment varaibles with example?

1142

Have you used rollup component? Describe how.

1121

What is the difference between sandbox and EME?

1312

What parallelisms does Abinitio support?

1264

What is a deadlock and how it occurs?

1202

How do you truncate a table?

1219

What is the difference between rollup and scan?

1931

State the relation between EME, GDE and Co-operating system?

1195

Explain the methods to improve performance of a graph?

1157

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1308

Describe the Evaluation of Parameters order.

1 1938

Un-Answered Questions { Data Warehouse }

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2103

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2606

can we override a native sql query within informatica? Where do we do it? How do we do it?

1115

Explain the definition of normalized and denormalized view and what are the differences between them?

979

What is Indexing? how did u implement indexing?

2574

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1086

what are the different views that are considered when building an object-oriented software system?

1082

Is microstrategy desktop available in other languages?

1060

What is the multi-insert?

1087

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1089

How do you load only null records into target? Explain through mapping flow.

2077

How to configure mapping in informatica?

1226

What parallelisms does Abinitio support?

1264

What is the difference between user and versatile user?

1149

do you need to know if there are any missing values? : Sas programming

1130

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