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?

1019

What is difference between primary key and unique key constraints?

948

Define query items?

971

What are the different uses of a repository manager?

1036

Define dimensions?

983

Why need staging area database for dwh?

1035

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

1006

Give the advantages of cognos?

995

Name the types of gateway?

971

Explain the characteristics of cognos?

1000

Name the types of report?

916

What are the advantages of shortcuts?

925

Define olap designer?

1081

Define report item?

1115

Can you define drill across?

932

Un-Answered Questions { Data Warehouse }

Differentiate between Join, Merge and Lookup stage?

1046

Explain how to export mappings to the production environment?

930

What is job control?

1052

can be used COM component in Informatica ?

2029

What is the difference between server job and parallel jobs?

1104

Mention the difference between ‘macros’ and ‘prompt’?

1070

Describe the function and utility of the most difficult SAS macro that you have written?

2500

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

968

what is sysdba and sysdbc ? which has high priority ?

3775

What are the various kinds of the hash file?

1108

what is data access? : Sas-di

1088

How to a create header dynamically in a crosstab report in cognos 8.1?

2388

What are the steps required to kill the job in Datastage?

1164

Where do the datastage jobs get stored?

1159

What are the different functions performed in development phase?

1027

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