Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

What is a design?

1 3931

How to delete duplicate records in a flat file source?

2 8788

What is a configuration management?

1 4249

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 31298

what is the difference between lookupoveride and joiner?

3 7970

what is plsql table?

2 6580

how to declare array in plsql?

1 9535

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 18448

How many cubes create from a single model?

1 4708

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 6203

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 13792

How will you display "Mr" for male & "Mrs" for female in target table?

7 13138

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 9054

How will you combine 3 different sources with a single source?

3 8808

how will you get 21 to 30 record from 50 records?

6 11972

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the limitations of joiner transformation?

1183

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1065

Explain the types of lookup transformation?

1109

How do you load only null records into target?

1258

What are the different types of transformation available in informatica.

1149

Define joiner transformation?

1107

How you can differentiate between connected lookup and unconnected lookup?

1108

Briefly explain the aggregator transformation?

1068

How can we improve session performance in aggregator transformation?

1159

Name the different lookup cache(s)?

1296

What are the data movement modes in informatica?

1213

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2188

How to delete duplicate row using informatica?

1092

what is size of u r database?

2367

What are the types of caches in lookup?

1096

For More Un-Answered { Informatica } Questions Click Here