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 3081

Why use shortcuts(Instead of making copies).

1 3518

where is the reject loader .

1 2735

How do you use reject loader.

2602

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

1 3801

Differences between version 7.x and 8.x.

Accenture, Cognizant,

1893

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.

2356

Mapplets can you use an active transformation in a mapplet,

1 3321

What are active transformations? Name them.

1 2611

Can you use flat files in Mapplets.

2649

How many transformations can be used in mapplets.

1935

Can a joiner be used in a mapplet.

1 4111

What are active transformations.

1654

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

1 2843

Global and Local shortcuts. Advantages.

2032

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1123

What are the different ways to implement parallel processing in informatica?

1423

How identifying bottlenecks in various components of informatica and resolving them?

1132

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

How big was your fact table

1803

What is meant by lookup transformation? Explain the types of lookup transformation?

948

What is the difference between router and filter?

1268

How would you copy the content of one repository to another repository?

1016

wf dont have integration severances how you can run?

1938

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1165

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2121

Can informatica load heterogeneous targets from heterogeneous sources?

1185

Explain in detail scd type 2 through mapping.

1041

What is meant by LDAP users?

1208

Explain joiner transformation in informatica

1124

For More Un-Answered { Informatica } Questions Click Here