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 session partitioning?

1 1942

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

5 16538

Identifying the bottlenecks in various components of Informatica and resolving them.

1 2003

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 4304

what is pmrep command?

2 11683

what happens if the info.server doesn't find the session parameter in the parameter file?

1 5588

Can u access a repository created in previous version of Informatica?

1 1913

Eliminating of duplicate records without using dynamic lookups

3 7991

what are Lookup caches options? Including persistent caches.

1 4941

Difference between flat files and relational sources?

2 6419

what is session partitioning?

1 2215

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 7402

Identifying the bottlenecks in various components of Informatica and resolving them.

1 2677

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

2 8520

what are the different forms of normalization?

2 5924

Un-Answered Questions { Data Warehouse }

EXL informatica Questions

1460

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

How do you remove duplicate records in informatica? And how many ways are there to do it?

1232

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

2207

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2093

Hi, If anyone has base SAS certification dumps, please share.

1937

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

1670

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

2824

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

Write the unconnected lookup syntax?

1146

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2262

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

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

2299

what are the names of the reports that you prepared?

1193

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