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 3765

How to delete duplicate records in a flat file source?

2 8576

What is a configuration management?

1 4067

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

Amazon, IBM, Wipro,

9 30653

what is the difference between lookupoveride and joiner?

3 7696

what is plsql table?

2 6293

how to declare array in plsql?

1 9362

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

Cap Gemini, IBM,

4 18076

How many cubes create from a single model?

1 4539

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 6035

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

Cegedim,

5 13437

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

7 12676

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

4 8737

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

3 8470

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

6 11565

Post New Informatica Questions

Un-Answered Questions { Informatica }

Where is metadata stored?

1051

Briefly describe lookup transformation?

994

Explain the scenario which compels informatica server to reject files?

1096

What is a code page?

1126

What is the use of an aggregator cache file?

1146

Explain why we use partitioning the session in informatica?

1020

What is lookup change?

997

can we override a native sql query within informatica? How do we do it?

1064

Explian the Process of deployment groups in informatica

1000

How do you load alternate records into different tables through mapping flow?

1814

Why do you use Mapping Parameter and mapping variable?

1690

What are the modules in Power Center

1633

how to load dimension table and fact table. plz tell me the steps.

2045

What is informatica?

1086

what are 3 tech challenges/ common issues you face?

2289

For More Un-Answered { Informatica } Questions Click Here