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

Is stop and abort are same in informatica?

1014

Do you find any difficulty while working with flat files as source and target?

1113

What is pmcmd command?

1137

What is a surrogate key?

1095

What do think which one is the better joiner or look up?

1216

Could you explain what is enterprise data warehouse?

1166

How can we handle two sessions in informatica?

1046

What is domain in terms of informatica?

1025

Explain sessions?

1082

What is a mapplet/worklet in informatica?

1200

In warehouses how many schemas are there?

1089

What you know about transaction control transformation?

1008

Describe an informatica powercenter?

1143

What is the cumulative sum and moving sum?

1200

What is the meaning of decode in informatica?

1137

Un-Answered Questions { Data Warehouse }

What is partitioning? Explain different types of partitioning?

1259

What is object stores?

1001

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

979

Explain are data mart and dwh normalized or denormalized? Do both of them exist in

1049

Explain what is the extension of file to save template?

987

differentiate between view and materialized view?

What does Amp contain and what are all the operations that it performs?

1015

What is meant by incremental aggregation?

1126

How to a create header dynamically in a crosstab report in cognos 8.1?

2450

What is ds designer?

1117

Target increases every day even though no new record was inserted

1596

What is called dimensional modelling?

1129

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1026

What is the difference between partitioning with key / hash and round robin?

1400

What is the meaning of Caching in Teradata?

1153

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