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?

1 1384

What is the meaning of Caching in Teradata?

1 1192

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

1 1236

What is meant by a Channel Driver?

1 1352

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

1 1145

What happens when a node suffers a downfall?

1 1195

What are the functions of a Parser?

1 1206

What is meant by Teradata Gateway?

1 1118

Highlight the differences between Primary Key and Primary Index.

1 1163

What is meant by a Clique?

1 1125

Explain the meaning of Amp?

1 1261

In Teradata, what is the significance of UPSERT command?

1 1346

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

1 1095

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

1 1020

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

1 1068

Un-Answered Questions { Data Warehouse }

what are the data modeling tools you have used?(polaris)

2055

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

What is dimensional table?

1152

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2300

draw informatica architecture 8.6 ?

3939

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415

What sort of existing documents should business analysts refer to when starting on a new project?

1074

EXL informatica Questions

1451

explain in detail about type 3?

1078

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

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