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 different dimensions.

972

Differentiate between source qualifier and filter transformation?

1584

Explain scd type 3 through mapping.

1023

What is dimensional table?

1072

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1588

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1128

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1174

Explain in detail about scd type 1 through mapping.

1559

Write the unconnected lookup syntax?

1087

Write the unconnected lookup syntax and how to return more than one column.

1113

How do you remove duplicate records in informatica? And how many ways are there to do it?

1171

What is dimensional table? Explain the different dimensions.

1175

What are the types of caches in lookup?

1053

What are the types of caches in lookup? Explain them.

972

Differentiate between router and filter transformation?

1018

Un-Answered Questions { Data Warehouse }

Separate from an archive server and a powerhouse?

965

U r project in which stage in implementation?

2526

What commands are used in the case of including or excluding any specific variables in the data set?

1098

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2158

Define catalog in cognos and write its various types?

1186

What is a predefined event?

1097

Which studio is used to create reports?

1115

What is usage analysis in datastage?

1313

Do you need to rearrange the order of the data for the report?

2311

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2224

How can I remove header from output data set?

2632

What is difference between server jobs & parallel jobs?

1042

What are snapshots?

988

Could anyone give brief explanation bout datastage admin

2356

How to join three sources using joiner?

1122

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