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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the active and passive transforamtions?

2 7580

What are the connected or unconnected transforamations?

2 7133

How many ways you create ports?

1 6063

What are the reusable transforamtions?

2 6238

What are the methods for creating reusable transforamtions?

2 6219

What are the unsupported repository objects for a mapplet?

Informatica,

1 9014

What are the mapping paramaters and mapping variables?

1 5998

Can yoU use the maping parameters or variables created in one maping into another maping?

2 7312

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 5798

How can yoU improve session performance in aggregator transformation?

TCS,

8 27716

What are the diffrences between joiner transformation and source qualifier transformation?

2 17323

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 10816

what are the settiings that u use to cofigure the joiner transformation?

2 6648

What are the join types in joiner transformation?

Informatica,

1 6488

What are the joiner caches?

Informatica,

3 17749

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1126

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

Which is the t/r that builts only single cache memory?

1190

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167

What are mapplets?

1271

Sequence generator, when you move from develoment to production how will you reset

2038

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7064

what is INFORMATICA TESTING process

2290

What is a pre-defined event and user-defined event?

1037

What is transformation?

1099

What are the types of lookup transformation?

1081

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

What does reusable transformation mean?

1132

What are the steps involved in the migration from older version to newer version of Informatica Server?

2109

What is the use of source qualifier?

1138

For More Un-Answered { Informatica } Questions Click Here