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

What are the tasks that can be performed using sq?

1107

What is a filter transformation?

1054

What is workflow monitor?

1073

What is repository manager?

999

What is sq transformation?

1179

Explain the types of transformations?

1080

Explain the difference between a data warehouse and a data mart?

1068

What is an expression transformation?

1034

What is an aggregator transformation?

1112

Explain the informatica workflow?

1083

What is rank transform?

1011

Mention some types of transformation?

1059

What is a router transformation?

1143

What are the popular informatica products?

1021

Why is the case expression used in teradata?

1095

Un-Answered Questions { Data Warehouse }

How to create Index to the table in the universe designer and how it improves the Query performence

2567

Highlight the points of differences between the database and user in Teradata.

1121

What is called a slice?

1038

what are informats in sas? : Sas-administrator

1106

How can the user determine the object id of an object?

950

What is meant by query override?

1070

What are pdv and it functions?

1166

define snapshot?

How to do performance tunning of reports?

2329

What is meant by incremental aggregation?

1123

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1168

What is the difference between microstrategy and cognos reporting tool?

1002

What is informatica architecture?

1077

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1100

What do you mean by enterprise data warehousing?

1075

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