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?

1384

What is the meaning of Caching in Teradata?

1192

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

1232

What is meant by a Channel Driver?

1345

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

1145

What happens when a node suffers a downfall?

1195

What are the functions of a Parser?

1202

What is meant by Teradata Gateway?

1118

Highlight the differences between Primary Key and Primary Index.

1159

What is meant by a Clique?

1125

Explain the meaning of Amp?

1257

In Teradata, what is the significance of UPSERT command?

1343

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

1095

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

1020

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

1066

Un-Answered Questions { Data Warehouse }

Explain what is SAS informats?

1141

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5817

what are several options for creating reports in web report studio? : Sas-bi

1235

explain about sas business intelligence? : Sas-bi

1205

When do you use sql override in a lookup transformation?

1152

What is vdl (view definition language) explain?

1113

Mention what is abinitio?

1057

what is the use of proc contents and proc print in sas? : Sas-administrator

1114

What is the syntax for case when statement?

1229

What is meant by a Channel Driver?

1345

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2523

what is data governance? : Sas-di

1069

Explain microstrategy logical primary keys?

1049

What are materialized views & where do we use them?

1083

What are target types on the server?

1049

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