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 3851

How to delete duplicate records in a flat file source?

2 8684

What is a configuration management?

1 4163

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

Amazon, IBM, Wipro,

9 30988

what is the difference between lookupoveride and joiner?

3 7837

what is plsql table?

2 6434

how to declare array in plsql?

1 9459

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

Cap Gemini, IBM,

4 18257

How many cubes create from a single model?

1 4626

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 6116

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

Cegedim,

5 13635

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

7 12927

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

4 8909

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

3 8640

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

6 11749

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is native users?

1157

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1125

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2064

What is intricate mapping?

1202

How to configure mapping in informatica?

1173

What is parallel processing in informatica?

1712

Is there any target staging area in informatica not staging area

2578

Explain incremental aggregation in informatica

1127

What are the components of workflow manager?

1096

What are the informatica performance improvement tips

1093

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

what is the size of your data warehousing?

2095

tell me the rules and responsblites in our project(my project is development)

1933

What is Data Caches size?

1091

For More Un-Answered { Informatica } Questions Click Here