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

What is the difference between the local container and shared container?

1103

What are the repository tables in datastage?

1309

What are the job parameters?

1221

What is the difference between server job and parallel jobs?

1155

What is active and passive stage?

1414

What can we do with datastage director?

1238

What is the difference between datastage and informatica?

1118

What is oci?

1301

What are the components of ascential data stage?

1189

What is the difference between account and directory options ?

1182

What are sequencers?

1116

How and where you used hash file?

1174

What are the types of views in datastage director?

1775

How do you register plug-ins?

962

What is orabulk stage?

1047

Un-Answered Questions { Data Warehouse }

What is the basic syntax for teradata select statement?

1047

Define bulk load mode?

What is session task and command task?

1298

Describe routines in datastage? Enlist various types of routines.

1016

What are the frequently used data types in teradata?

1083

What are the important Features of Redshift?

What is difference between user and database in teradata?

1069

Which command using Query Analyzer will give you the version of SQL server and operating system ?

5069

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

1047

What is interleaving in SAS?

1114

How to get the first 100 rows from the flat file into the target?

1210

What exactly do you know about the typical data analysis?

1106

How to read multiple files using a single datastage job if files have the same metadata?

1252

When we use aggregate awareness function in designer?

979

What is a merge in datastage?

1271

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