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 many Nodes configuration file you used in your last project?

1 4365

Tell me the syntax of Configuration file?

1 5073

Explain the situation where you have applied SCD in your project?

2090

What are the third party tools you used in your project?

IBM,

1 3385

How do you design PX Routines ?

1 3489

What is the use of Row generator stage?

2 13413

How you Implemented SCD Type 1 & Type 2 in your project?

4181

On which Dimension Table you implemented SCD Type in your Project

2116

How you Remove the Dataset in Unix?

5 21896

What is the difference b/w Hash file and Lookup Fileset stages?

1 11013

What is the default padding character?

IBM,

3 15827

What are the partition techniques available in your last project?

1 5411

What is the default execution order of the sequential file?

3 13966

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

SS Solutions,

1 7089

How many input links can you give to a Transformer stage?

6 27221

Un-Answered Questions { Data Warehouse }

Is there any other repository domains rather than universe, security, document?

1091

What we will do with the universe for faster process?

1036

Explain when we use aggregate awareness function in designer?

1091

Why is auto-regression used in forecasting used on cognos platform?

1075

Mention some types of transformation?

1101

what are the facilities provided by data warehouse to analytical users?

2124

Differentiate between Join, Merge and Lookup stage?

1147

explain html document?

1074

What is a Query Subject?

1146

how to create user defined function (udf) in informatica

1354

i was asked what are the caluclations done by you in your report? plz give reply

2248

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

972

What does role playing dimension mean?

1098

How we can create indexes after completing the load process?

1205

Is redshift can be used with AWS RDS?

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