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

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

1 6726

What is batch and describe about types of batches?

2 12351

Can you copy the batches?

3 10814

How many number of sessions that u can create in a batch?

3 10627

When the informatica server marks that a batch is failed?

2 6808

What is a command that used to run a batch?

4 12280

What are the different options used to configure the sequential batches?

Wipro,

2 9371

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

3 7178

Can you start a batches with in a batch?

1 6258

Can you start a session inside a batch individually?

2 9392

How can u stop a batch?

2 7067

What are the session parameters?

3 15356

What is parameter file?

2 6897

How can you access the remote source into your session?

1 6357

What is difference between partioning of relatonal target and partitioning of file targets?

2 13978

Un-Answered Questions { Data Warehouse }

What is microstrategy?

1033

Can you explain cognos planning?

1135

Differentiate between a repository server and a powerhouse?

1193

What are the benefits of datastage?

1313

What is the difference between a cascading report and drill through report?

1125

What task is 98% of the required work of a business analyst?

1127

Mention what is rollup component?

1187

Do you view contain data?

1013

Highlight a few of the advantages that ETL tools have over Teradata.

1142

Why do you need stage variables?

1237

what is sas olap server? : Sas-di

1307

List out some key concept of SAS

1221

What are “business rules” in ab initio business rules environment (bre)?

2099

What are the programs that we can do with the microstrategy architect?

1102

What is a pdv and what are its functions?

1227

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