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

Informatica Interview Questions

Questions Answers Views Company eMail

What are pre and post-session shell commands?

1311

How does the aggregator transformation handle null values?

1149

What are the performance considerations when working with aggregator transformation?

1152

When do you use sql override in a lookup transformation?

1098

How does a sorter cache works?

1069

State the differences between sql override and lookup override?

1207

Name the different lookup cache(s)?

1233

How many input parameters can exist in an unconnected lookup?

1545

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

What are the advantages of using informatica as an etl tool over teradata?

1022

What are some examples of informatica etl programs?

940

Describe data concatenation?

1082

Define the various join types of joiner transformation?

988

What are the new features of informatica 9.x in developer level?

998

How to use pmcmd utility command?

1032

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the tuning lookup transformation - informatica

993

What are the reusable transformations?

1162

What are the modules in Power Center

1680

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1123

What do think which one is the better joiner or look up?

1203

What is a joiner transformation?

995

What are the limitations of joiner transformation?

1112

What are the informatica performance improvement tips

1093

What all are steps in up gradation of Informatica server?

1045

How do you change a non-reusable transformation to reusable transformation?

999

What is flashback table ? Advance thanks

1932

Difference between Data and Index Caches?

1137

What is union transformation in informatica?

1146

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

What is informatica etl tool?

999

For More Un-Answered { Informatica } Questions Click Here