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 is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 63326

What is the difference between Normal load and Bulk load?

5 50978

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46795

what is a time dimension? give an example?

IBM,

2 12612

What are the reusable transforamtions?

1 5025

What is aggregate cache in aggregator transforamtion?

5 9835

What are the basic needs to join two sources in a source qualifier?

3 7315

In which circumstances that informatica server creates Reject files?

2 10175

Can you copy the session to a different folder or repository?

2 11797

When the informatica server marks that a batch is failed?

1 6004

What is a command that used to run a batch?

2 7511

In a sequential batch can you run the session if previous session fails?

4 10894

Define informatica repository?

Wipro,

2 12075

What are the types of metadata that stores in repository?

2 11049

What is tracing level and what are the types of tracing level?

TCS,

2 38138

Un-Answered Questions { Data Warehouse }

Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?

914

Can you explain a cognos controller?

1021

what is the use of catlog or catlogfile?

2380

Mention sas system options to debug sas macros.

1177

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

Explain about compound key?

1080

What is a merge in datastage?

1270

do you need to know if there are any missing values? : Sas programming

1058

how we can load rejected record's at run time?(not through bad files)

2379

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

Explain the data types present in bo and what happens if we implement view in the designer and report?

1029

Explain what are the different types of join operations?

973

Explain sessions and how many types of sessions are there?

1009

Can you define cognos decision stream?

992

what are the different authentication modes available in microstrategy?

1107

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