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 the datastage parallel extender (px) or enterprise edition (ee)?

1295

How many types of sorting methods are available in datastage?

1126

What is the process of killing a job in datastage?

1077

What is the different type of jobs in datastage?

1037

What are the stages in datastage?

1149

What are some different alternative commands associated with "dsjob"?

1223

State the difference between an operational datastage and a data warehouse?

1190

Which commands are used to import and export the datastage jobs?

1473

What is a quality stage in datastage tool?

1139

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

1310

What are some prerequisites for datastage?

1181

If you want to use the same piece of code in different jobs, how will you achieve it?

1226

What is "fatal error/rdbms code 3996" error?

1350

Describe routines in datastage? Enlist various types of routines.

1068

Describe stream connector?

1369

Un-Answered Questions { Data Warehouse }

What is the difference between snowflake and star schema?

1108

Tell me what is degree of a relation?

1060

What is sandbox?

1266

What is a transaction control transformation?

1270

Is there a difference between view filter and report filter?

969

Your account is locked and your administrator has forgotten the password. What would you do?

1112

What is data warehosuing hierarchy?

1278

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?

1086

What is the function of union transformation?

1211

How can we schedule the graph in unix?

1048

Explain is there any other repository domains rather than universe, security, document?

1190

What is maximum number of rows and cols can be handled in SAS?

1687

Explain some differences between mpp and smp?

1167

What are all the types of hierarchies?

1190

What are the various indexes in teradata? How to use them?

1077

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