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 we can create indexes after completing the load process?

1160

What is the surrogate key?

1264

Why is sorter an active transformation?

1129

Define sessions in informatica etl?

1035

Define filter transformation?

1099

What is meant by a domain?

1128

What is the benefit of partitioning a session?

1182

Explain the difference between mapping parameter and mapping variable?

1041

What are the various types of transformation?

1180

Write the prerequisite tasks to achieve the session partition?

1160

What is the reusable transformation?

1047

What is meant by active and passive transformation?

1125

What is the difference between a repository server and a powerhouse?

1513

Define mapplet?

1013

Explain the scenario which compels informatica server to reject files?

1168

Un-Answered Questions { Data Warehouse }

What is the difference between filter and lookup transformation?

1109

How many data types are there in SAS?

1078

What are the factors on which storage of data depends?

1166

what is function of retain statment

2041

How to open a universe with out using the Designer ??

7603

Explain the situation where you have applied SCD in your project?

2040

What are the different types of schemas used in data warehousing?

950

what are the production issues in datastage?

10421

What is a relationship?

993

What are logical views used for in microstrategy?

965

What is the difference between informatics 7x and 8x and what is latest version?

1085

describe about metadata object? : Sas-di

1071

tell me few points when u become TL

2556

Can you define a datastore in cognos?

1039

What was the last computer book you purchased? Why?

2374

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