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?

941

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 }

How can informatica be used for an organization?

1219

What are the components of workflow manager?

1096

Does an informatica transformation support only aggregate expressions?

1042

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10682

What is a stored procedure transformation?

1053

Mention few power centre client applications with their basic purpose?

951

What is domain in terms of informatica?

1007

What are the tasks that source qualifier perform?

1105

Describe an informatica powercenter?

1127

Define mapplet?

1008

4 yrs etl devloper roles and responsibilities?any body give solutions

2168

What are connected or unconnected transformations?

1122

How can we use mapping variables in informatica? Where do we use them?

1200

How do you load first and last records into target table?

1159

What does “tail –f” command do and what is its use as an Informatica admin.

1106

For More Un-Answered { Informatica } Questions Click Here