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 7041

what are summary filters? grouped filters?

IBM,

3 7292

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

7 12985

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

4 8932

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

3 8666

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

6 11793

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

7 18782

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

3 9226

Without source how to insert record to target?

6 19822

How to jion 2 tables, without using any condition?

Amazon,

11 37762

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

4 11104

In joiner, how to load Master table in Target?

2 7907

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

CTS,

5 14150

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

1 6488

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

3 12034

Un-Answered Questions { Data Warehouse }

What are the different clients of powercenter?

1079

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2270

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

1137

Explain what are the different versions of informatica?

1112

What are the new features of informatica 9.x developer?

982

Mention sas system options to debug sas macros.

1193

What is the difference between source qualifier transformations source filter to filter transformation?

1063

What is persistent lookup cache?

1040

what are the all possible features supported modify stage?

2156

How do you start developing a datastage project?

1125

What is recovering sessions?

952

What are the different ways to implement parallel processing in informatica?

1436

What are the various methods of getting incremental records or delta records from the source systems?

943

Explain the purpose of retain statement.

1079

What do you understand by the term 'dynamic cube'?

1027

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