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

Mention some common errors that are usually committed in sas programming.

1066

What do you know about sas data set?

1132

Explain the purpose of substr functions in sas programming.

1076

Which command is used to save logs in the external file?

1120

Mention few ways with which a “table lookup’ is done in sas programming.

1 1588

Mention sas system options to debug sas macros.

1193

Enlist the syntax rules followed in sas statements.

1096

Explain the use of proc print and proc contents?

975

Describe primary index in teradata?

1011

Describe primary index in teradata. And what are the available primary index types?

1014

What is partitioned primary index (ppi)?

1066

What are the main components of teradata system?

1158

Explain the term 'columns' related to relational database management system?

1085

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1034

What is the purpose of upsert command?

1192

Un-Answered Questions { Data Warehouse }

what are the reports developed in sap bw project and what is the requirement for developing it?

2195

What are the different types of data warehouses?

1099

How many number of sessions can one group in batches?

1184

Explain the difference between informat and format with an example.

1184

Where are the source flat files kept before running the session?

1104

What is metadata in microstrategy?

1129

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2051

Explain the data types present in bo and what happens if we implement view in the designer and report?

1038

Difference between flat files and relational sources?

2255

-----------With out using DrillThrough how to do Reports?

2064

Are you involved in writing the inferential analysis plan? Tables specifications?

3975

What is factor analysis?

1149

What does Amp contain and what are all the operations that it performs?

1015

what are 3 tech challenges/ common issues you face?

2357

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5086

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