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 target designer and target load order?

1 1182

How to update source definition?

1 1160

What is standalone command task?

1 1397

What is event and what are the tasks related to it?

1 1234

What is informatica powercenter repository?

1 1270

What are the databases that informatica can connect to windows?

1 1127

What is decode in informatica?

1 1287

What is the benefit of session partitioning?

1 1170

What is substr in informatica?

1 1287

Enlist some properties of sessions.

1 1150

What is transformation?

1 1165

What is workflow? What are the components of workflow manager?

1 1249

Mention few advantages of router transformation over filter transformation.

1 1087

Enlist the advantages of informatica.

1 1125

What is session task and command task?

1 1433

Un-Answered Questions { Data Warehouse }

Explain how to generate iqd file from framework manager?

1020

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1099

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4191

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

1667

Explain about a time when you discovered a more efficient way to do a work task?

1222

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

EXL informatica Questions

1459

Have you have ever worked in unix environment and why it is useful in datastage?

1213

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1199

Explain scd type 3 through mapping.

1070

draw informatica architecture 8.6 ?

3945

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

845

Demonstrate experience in maintaining quality process standards?

2670

What is dimensional table? Explain the different dimensions.

1267

Write the unconnected lookup syntax?

1145

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