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

How to differentiate between the active and passive transformations?

1182

What is source qualifier transformation in informatica?

1026

What is powercenter on grid?

1198

What is enterprise data warehousing?

1059

What is the format of informatica objects in a repository?

1030

Enlist the differences between database and data warehouse.

1132

What is decode in static cache?

1196

What is a pre-defined event and user-defined event?

1052

Enlist the various types of transformations.

1080

What are the different components of powercenter?

1069

Enlist the tasks for which source qualifier transformation is used.

1054

Explain the features of connected and unconnected lookup.

945

What is informatica? Why do we need it?

1121

What is incremental aggregation?

1097

What is joiner transformation in informatica?

1061

Un-Answered Questions { Data Warehouse }

What are the enhancements made in datastage 7.5 compare with 7.0?

1160

Define olap designer?

1142

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3807

what are several options for creating reports in web report studio? : Sas-bi

1170

How will you go about adding additional column to the repository in the presentation layer?

932

Explain what task is 98% of the required work of a business analyst?

1120

CHANGE CAPTURE

1316

Compare sas with other data analytics tools.

1044

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1223

How many types of stage?

1190

How to convert a numeric variable to a character variable?

1219

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1053

What are the steps to create a repository in ab initio?

1267

What is data type of the surrogate key?

1014

explain abt ur project architecture?

2205

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