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

What is the difference between router and filter?

1380

Can you highlight the main features of ibm infosphere information server?

1129

What are the areas of application?

1202

What is job control?

1205

What is the precedence of stage variables,derivations, and constraints?

1130

What could be a data source system?

1098

What a datastage macro?

1104

Why do you need stage variables?

1232

On which interface you will be working as a developer?

1106

What are data elements?

1237

What is the difference between in process and inter process?

1205

Highlight the main features of datastage?

1224

What are the types of hashed files in data stage

1146

What is difference between server jobs & parallel jobs?

1091

What are the main differences you have observed between 7.x and 8.x version of datastage?

1135

Un-Answered Questions { Data Warehouse }

What is workflow manager?

1106

what is sas business intelligence? : Sas-bi

1271

What is a fantrap in business objects?

1235

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1210

In Which Transformation We Can Use Having Clause In Informatica?

1299

Is it possible to apply themes to microstrategy web? How?

1004

If a variable contains only numbers, can it be a character data type?

1147

Identifying the bottlenecks in various components of Informatica and resolving them.

1983

What is different between the data warehouse and data mart?

1114

can we override a native sql query within informatica? How do we do it?

1186

What are the things to be considered while creating secondary index?

1150

How to call shell scripts from informatica?

1045

State the differences between shortcut and reusable transformation

1119

How can repository reports be accessed without sql or other transformations?

1271

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2555

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