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

Informatica Interview Questions

Questions Answers Views Company eMail

What is a parameter When and where do you them when does the value will be created

1761

Design time, run time. If you don't create parameter what will happen

1802

What are variable ports and list two situations when they can be used?

1 2836

What are the parts of Informatica Server?

Cognizant,

1 3364

How does the server recognize the source and target databases. Elaborate on this.

1 3977

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 3473

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 3389

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 3210

server hot-ws270 is connect to Repository B. What does it mean?

Cognizant,

2454

How do you do error handling in Informatica?

1 7970

How do you implement scheduling in Informatica?

1 3648

What is the meaning of up gradation of repository?

1907

How can you run a session without using server manager?

1 4234

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 4130

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1983

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to improve the performance of a session using sorter transformation?

1098

What is lookup change?

998

What is Session and Batches?

1048

Which transformation should we use to normalise the COBOL and relational sources?

1148

How to elaborate powercenter integration service?

1083

Explain what transformation and how many are there in informatica?

897

Explain dynamic target flat file name generation in informatica

1015

How to generate sequence numbers without using the sequence generator transformation?

1127

How can you define user defied event?

986

What are the designer tools for creating transformations?

1054

What are connected or unconnected transformations?

1056

What is the benefit of session partitioning?

1056

During the running session, output files are created by informatica server. Enlist few of them.

943

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1734

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2031

For More Un-Answered { Informatica } Questions Click Here