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

Why do we use exception activity in Datastage?

1314

What is the meaning of Caching in Teradata?

1141

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1153

What is meant by a Channel Driver?

1249

How many sessions of MAX is PE capable of handling at a particular time?

1082

What happens when a node suffers a downfall?

1131

What are the functions of a Parser?

1113

What is meant by Teradata Gateway?

1058

Highlight the differences between Primary Key and Primary Index.

1091

What is meant by a Clique?

1064

Explain the meaning of Amp?

1152

In Teradata, what is the significance of UPSERT command?

1234

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1048

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

969

What does Amp contain and what are all the operations that it performs?

1005

Un-Answered Questions { Data Warehouse }

------------------What is Inline Query?

2227

What interface is used to connect to windows based applications?

1115

Explain what is informatica metadata and where is it stored?

1051

How do you convert single row from source into three rows into target?

1157

Reusable transformation and shortcut differences

1840

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

2040

how much memory space occupied real time project (roughly)?

2225

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2156

How do you design a report which has multiple child datastream (horizontal seq)

2603

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1921

Explain about a task that really tested your analytical abilities?

1249

How to move or copy the project parameter or project object to my sandbox?

2308

What is called dimensional modelling?

1111

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

What is the difference between project backlog and product backlog?

1536

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