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

Distinguish between informatica & datastage. Which one would you choose and why?

1 1074

How do you import and export the datastage jobs?

1 1231

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1 1121

What are the steps needed to create a simple basic datastage job?

1 1330

What is informatica worklet?

1 1133

How to elaborate powercenter integration service?

1 1194

How can we use batches?

1 1082

What is rank transformation?

1 1043

What is rank index in rank transformation?

1 1153

What is aggregator transformation in informatica?

1 1019

How you can differentiate between connected lookup and unconnected lookup?

1 1127

What is union transformation in informatica?

1 1212

How can we create index after completion of load process?

1 1183

What is mapplet in informatica?

1 1158

Enlist few areas or real-time situations where informatica is required.

1 1168

Un-Answered Questions { Data Warehouse }

what are the names of the reports that you prepared?

1192

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2173

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2298

What is dimensional table? Explain the different dimensions.

1267

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2491

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2059

EXL informatica Questions

1459

draw informatica architecture 8.6 ?

3945

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

4191

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2822

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

2127

Are you involved in writing the inferential analysis plan? Tables specifications?

4018

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

1769

What is dimensional table?

1159

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