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

1818

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

1837

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

1 2913

What are the parts of Informatica Server?

Cognizant,

1 3469

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

1 4077

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 3567

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

1 3470

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

1 3298

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

Cognizant,

2565

How do you do error handling in Informatica?

1 8061

How do you implement scheduling in Informatica?

1 3749

What is the meaning of up gradation of repository?

1988

How can you run a session without using server manager?

1 4369

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 4251

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?

2026

Post New Informatica Questions

Un-Answered Questions { Informatica }

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2120

What are the differences between a connected lookup and unconnected lookup?

1070

What is mapping debugger?

1012

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

What are the differences between source qualifier and joiner transformation?

1062

What are some examples of informatica etl programs?

942

What is flashback table ? Advance thanks

1934

What is the session task and command task?

1058

What are the performance considerations when working with aggregator transformation?

1152

In informatics server which files are created during the session rums?

1115

What is the scenario which compels informatica server to reject files?

1070

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

What is the Process to creating lookup transformation in informatica

1044

What are the data movement modes in informatica?

1153

What is rank index in rank transformation?

1080

For More Un-Answered { Informatica } Questions Click Here