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 a three-tier data warehouse?

1157

Difference between stored procedure and macro?

1224

What is multi insert?

1113

Different phases of multiload?

1068

What is the maximum number of dml can be coded in a multiload script?

1157

Did you write stored procedures in teradata?

1193

What is inner join and outer join?

1180

How to view every column and the columns contained in indexes in teradata?

1103

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1323

What is the use of having index's on table?

1 2524

Difference between inner join and outer join?

1084

What are the functions of a teradata dba?

1131

What are the various reporting tools in the market?

1125

How to identify ppi columns?

1251

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1164

Un-Answered Questions { Data Warehouse }

What are the types of hashed files in data stage

1146

What is a rollup component?

1175

what are the considerations when picking a SAS/STAT procedure?

3426

What is stored procedure in teradata?

1093

how do u really know that paging to disk is happening while u are using a lookup transform?

2482

What are the mapping paramaters and maping variables?

1085

How to run a graph infinitely?

1164

What is the maximum number of dml can be coded in a multiload script?

1157

What is oci?

1356

List out some key concept of SAS

1218

How to include or exclude specific variables in a data set?

1169

What are the features of ab initio?

1161

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1210

Imagine this, you are required to reset the password for all users at a time. How would you do that?

1010

What does sleep function does in fast load?

1213

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