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

Informatica Interview Questions

Questions Answers Views Company eMail

How does the session recovery work.

1 3171

Why use shortcuts(Instead of making copies).

1 3608

where is the reject loader .

1 2804

How do you use reject loader.

2652

Do you have to change the reject file b4 using reject loader utility.

1 3913

Differences between version 7.x and 8.x.

Accenture, Cognizant,

1943

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2405

Mapplets can you use an active transformation in a mapplet,

1 3403

What are active transformations? Name them.

1 2691

Can you use flat files in Mapplets.

2717

How many transformations can be used in mapplets.

1984

Can a joiner be used in a mapplet.

1 4195

What are active transformations.

1704

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 2908

Global and Local shortcuts. Advantages.

2092

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is fact table? Explain the different kinds of facts.

1129

Does an informatica transformation support only aggregate expressions?

1089

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.

1734

What are the informatica performance improvement tips

1152

What is option by which we can run all the sessions in a batch simultaneously?

1196

What is Cognos script editor?

4293

Do you find any difficulty while working with flat files as source and target?

1152

Explain the types of transformations?

1106

Explain the use of aggregator cache file?

1322

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

1081

What is parallel processing in informatica?

1797

what are 3 tech challenges/ common issues you face?

2397

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

1115

Differences between connected and unconnected lookup?

1273

State the limitations where we cannot use joiner in the mapping pipeline?

1109

For More Un-Answered { Informatica } Questions Click Here