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 session parameters? How do u set them?

2063

how do use session mapping parameters ?(in which transformation)

2032

what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?

1 4258

what is dynamic insert?

2219

what is pmrep command?

2445

what happens if the info.server doesn't find the session parameter in the parameter file?

1967

Can u access a repository created in previous version of Informatica?

1 3465

Eliminating of duplicate records without using dynamic lookups

IBM,

4 15566

what are Lookup caches options? Including persistent caches.

1990

Difference between flat files and relational sources?

Satyam,

2257

what is session partitioning?

1 4485

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

CTS,

2 7266

Identifying the bottlenecks in various components of Informatica and resolving them.

2 6052

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1979

how would u estimate the size of Aggregator transform data and index cache?

1976

Un-Answered Questions { Data Warehouse }

Explain about hash partitioning?

1020

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4018

How to select multiple values from type-in prompt?

1072

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

963

What is derived metric?

1001

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1280

how would u estimate the size of Aggregator transform data and index cache?

1976

What is recovering sessions?

958

Explain joiner transformation in informatica

1139

What do you mean by consolidations?

1059

Explain lookup transformation is active in informatica

1123

difference between informatica 8.1.1 and 8.6

3691

How Metrics Studio is better than Report Studio?

2622

Explain true primary keys?

1015

What are the differences between joiner transformation and source qualifier transformation?

1189

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