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?

1075

What is difference between primary key and unique key constraints?

990

Define query items?

1017

What are the different uses of a repository manager?

1100

Define dimensions?

1021

Why need staging area database for dwh?

1080

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

1073

Give the advantages of cognos?

1035

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?

1177

Can you define drill across?

980

Un-Answered Questions { Data Warehouse }

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068

State the working process of decimal_strip function?

2159

What do high confidence, low confidence and no confidence mean in explain plan?

1048

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2106

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

920

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1901

Give one reason when you need to consider multiple data processing?

1174

What is main advantage datawarehousing over oracle?

1004

What is the difference between datastage and informatica?

1118

What do you understand by overflow errors?

1243

Explain the difference between rolap and molap?

981

What kind of layouts does abinitio support?

1289

Why do you use Mapping Parameter and mapping variable?

1763

What is a merge?

1169

What is the difference between informatica 7.0 and 8.0?

1016

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