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?

1139

What is difference between primary key and unique key constraints?

1031

Define query items?

1056

What are the different uses of a repository manager?

1180

Define dimensions?

1065

Why need staging area database for dwh?

1125

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

1149

Give the advantages of cognos?

1092

Name the types of gateway?

1051

Explain the characteristics of cognos?

1090

Name the types of report?

1013

What are the advantages of shortcuts?

1011

Define olap designer?

1197

Define report item?

1255

Can you define drill across?

1036

Un-Answered Questions { Data Warehouse }

What is spool space? Why do you get spool space errors?

1088

how do u extract data from different data sources explain with an example?

2333

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2513

Difference between nodup and nodupkey options?

1276

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7598

How to improve session performance in aggregator transformation?

1032

What is an aggregator transformation?

1150

Explain entity, attribute and relationship in datastage?

1160

Have you used Unstructured data?

1377

Explain fact constellation schema?

1089

What is difference between page break and section report?

1260

What are the methods by which it non-durable model could be changed into the durable model?

1010

What is the difference between star and snowflake schemas?

1322

Differentiate between ceil and floor functions.

1203

what is intially documentation in sas?

5132

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