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?

1236

How does the aggregator transformation handle null values?

1085

What are the performance considerations when working with aggregator transformation?

1095

When do you use sql override in a lookup transformation?

1025

How does a sorter cache works?

1000

State the differences between sql override and lookup override?

1113

Name the different lookup cache(s)?

1158

How many input parameters can exist in an unconnected lookup?

1491

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

982

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

969

What are some examples of informatica etl programs?

887

Describe data concatenation?

1005

Define the various join types of joiner transformation?

941

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

937

How to use pmcmd utility command?

964

Post New Informatica Questions

Un-Answered Questions { Informatica }

Repository user profiles

1713

What is the procedure for creating independent data marts from informatica 7.1?

1000

how to load dimension table and fact table. plz tell me the steps.

2036

What does reusable transformation mean?

1069

What is lookup change?

986

What is the use of transformation?

945

What is mapping debugger?

944

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179

What is a transaction control transformation?

1143

Explain dynamic target flat file name generation in informatica

1008

What is meant by lookup transformation?

1034

explain one complex mapping with logic? sales project?

6593

What are the limitations of joiner transformation?

1045

I have a flat file, want to reverse the contents of the flat file

1065

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

1051

For More Un-Answered { Informatica } Questions Click Here