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

Informatica Interview Questions

Questions Answers Views Company eMail

Define informatica repository?

Wipro,

2 12082

What are the types of metadata that stores in repository?

2 11056

What is tracing level and what are the types of tracing level?

TCS,

2 38144

What are Target Options on the Servers?

1 6060

What is Code Page Compatibility?

1 8892

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42380

Why we use lookup transformations?

1 6327

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

TCS,

5 19137

Explain about perform recovery?

1 6816

How to recover sessions in concurrent batches?

1 12276

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 6424

How to recover the standalone session?

2 9480

What is difference between maplet and reusable transformation?

2 9985

What are the data movement modes in informatcia?

3 7619

What are the out put files that the informatica server creates during the session running?

2 7875

Post New Informatica Questions

Un-Answered Questions { Informatica }

How does a rank transform differ from aggregator transform functions max and min?

1213

What is the format of informatica objects in a repository?

1021

What happens when a session fails and you click on recover?

1123

Explain direct and indirect flat file loading (source file type) - informatica

1321

How to use procedural logic inside infromatica?

1249

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7078

What is a filter transformation?

1050

What is aggregator transformation in informatica?

955

what is the -ve test case in your project.

2411

What are the designer tools for creating transformations?

1120

What is the use of target designer?

1059

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1094

Explain the scenario which compels informatica server to reject files?

1171

Differentiate between source qualifier and filter transformation?

1584

difference between informatica 8.1.1 and 8.6

3683

For More Un-Answered { Informatica } Questions Click Here