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

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1073

What is difference between primary key and unique key constraints?

989

Define query items?

1017

What are the different uses of a repository manager?

1097

Define dimensions?

1020

Why need staging area database for dwh?

1080

What are shortcuts? Where it can be used? What are the advantages?

1072

Give the advantages of cognos?

1034

Name the types of gateway?

1010

Explain the characteristics of cognos?

1042

Name the types of report?

956

What are the advantages of shortcuts?

968

Define olap designer?

1131

Define report item?

1176

Can you define drill across?

980

Un-Answered Questions { Data Warehouse }

Explain microstrategy logical primary keys?

987

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2482

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

2428

What is the benefit of partitioning a session?

1182

How does a rank transform differ from aggregator transform functions max and min?

1204

Explain the difference between oltp and olap?

1122

What is the difference between a connected look up and unconnected lookup?

966

What is the difference between an operational datastage and a data warehouse?

1154

Define oconv () and iconv () functions in datastage?

1416

What is drill-through?

985

What is factless fact tables?

1210

Can you fastexport a field, which is primary key by putting equality on that key?

1178

What was the last computer book you purchased? Why?

2374

Whats there in global repository

1692

Give some examples where proc report’s defaults are same as proc print’s defaults?

1113

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