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 types of keys are there i.e primary key and foreign key etc..?

IBM,

3 7147

what are summary filters? grouped filters?

IBM,

3 7445

How will you display "Mr" for male & "Mrs" for female in target table?

7 13159

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 9079

How will you combine 3 different sources with a single source?

3 8827

how will you get 21 to 30 record from 50 records?

6 12014

how will you remove the duplicate records from flat file without using sorter?

7 18999

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 9353

Without source how to insert record to target?

6 20056

How to jion 2 tables, without using any condition?

Amazon,

11 38117

How to compare Source and Target table, without using dynamic lookup?

4 11255

In joiner, how to load Master table in Target?

2 7991

Without using Lookup & Sequence Generator, How to generate Sequence?

CTS,

5 14319

Is it possible to have "5 source & 5 Target" in single mapping?

1 6557

How to update records in Target, without using Update Strategy?

3 12162

Un-Answered Questions { Data Warehouse }

Hi friends, what are the new features in abinito3.0?

2851

Explain the methods to improve performance of a graph?

1161

Define Routines and their types?

1269

How do you load first and last records into target table?

1223

What is a dimension?

1081

How can we create a dynamic column name in cognos?

1011

Explain about scorecarding?

2124

What do you mean by channel change?

1122

in sap bi we have wad, then why we go for sap bo

3439

Can you filter data in hashed file?

3834

What is meant by a Channel Driver?

1345

Define olap designer?

1201

Explain difference between e-r modeling and dimentional modeling?

1042

What are the ETL Testing Operations?

1106

Explain lookup transformation in informatica

1136

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