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 steps involved in the migration from older version to newer version of Informatica Server?

2113

What are the main features of Oracle 8i with context to datawarehouse?

2115

What are the new features of Power Center 5.0?

1785

How to run a session, which contains mapplet?

1 4011

Differentiate between Load Manager and DTM?

2162

What are session parameters ? How do you set them?

1856

When do you use mapping parameters? (In which transformations)

1 4048

What is a parameter When and where do you them when does the value will be created

1825

Design time, run time. If you don't create parameter what will happen

1838

What are variable ports and list two situations when they can be used?

1 2919

What are the parts of Informatica Server?

Cognizant,

1 3483

How does the server recognize the source and target databases. Elaborate on this.

1 4084

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 3572

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 3480

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 3309

Un-Answered Questions { Data Warehouse }

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2053

Explain what is de-partition in abinitio?

1348

What are the other names given to data warehousing?

1099

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1159

what is a prompt value in report studio and variables ?

2717

What is a relationship?

999

What is the method of removing duplicates, without the remove duplicate stage?

1030

What’s the use AWS redshift cluster Service?

Highlight the differences between Primary Key and Primary Index.

1097

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1042

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

934

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

6913

Explain what is informatica metadata and where is it stored?

1053

What are the major challenges you faced while creating the rpd?

871

What is data transformation manager process?

1167

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