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?

1148

What is a filter transformation?

1097

What is workflow monitor?

1103

What is repository manager?

1030

What is sq transformation?

1238

Explain the types of transformations?

1115

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

1118

What is an expression transformation?

1084

What is an aggregator transformation?

1153

Explain the informatica workflow?

1129

What is rank transform?

1061

Mention some types of transformation?

1101

What is a router transformation?

1222

What are the popular informatica products?

1065

Why is the case expression used in teradata?

1148

Un-Answered Questions { Data Warehouse }

How to know the time taken for particular report execution?

1020

Explain is fact table?

980

---------------Describe OLAP Reporting and RDBMS Reporting?

2153

What is a Pivot?

1247

What is sq transformation?

1238

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1384

Can more than 1 metric be applied on an analytic in business objects?

2238

Explain what is the difference between a primary and secondary actor in use case modeling?

1125

State the relation between EME, GDE and Co-operating system?

1202

List out all forms of LOCKS that are available in Teradata.

1020

Name the types of gateway?

1054

What are default access rights in teradata? What explicit right can be given to a user?

1151

What are prompted filters?

997

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1967

What is the basic syntax for teradata select statement?

1109

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