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 3849

How to delete duplicate records in a flat file source?

2 8679

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 30966

what is the difference between lookupoveride and joiner?

3 7828

what is plsql table?

2 6425

how to declare array in plsql?

1 9451

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

Cap Gemini, IBM,

4 18248

How many cubes create from a single model?

1 4622

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 6114

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

Cegedim,

5 13618

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

7 12912

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

4 8903

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

3 8629

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

6 11742

Post New Informatica Questions

Un-Answered Questions { Informatica }

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2416

How to create a non-reusable instance of reusable transformations?

1121

How to elaborate tracing level?

1170

What are the types of schemas we have in data warehouse and what are the difference between them?

939

What is the surrogate key?

1253

What are the issues you have faced in your project? How did you overcome those issues?

2359

How can we improve session performance in aggregator transformation?

1111

Explain dynamic target flat file name generation in informatica

1045

What is the function of aggregator transformation?

1080

EXL informatica Questions

1384

What is meant by query override?

1055

What is joiner change?

1144

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2045

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

1113

What is parallel processing in informatica?

1709

For More Un-Answered { Informatica } Questions Click Here