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

1870

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

1895

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

1 2988

What are the parts of Informatica Server?

Cognizant,

1 3556

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

1 4145

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 3644

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

1 3545

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

1 3376

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

Cognizant,

2658

How do you do error handling in Informatica?

1 8147

How do you implement scheduling in Informatica?

1 3835

What is the meaning of up gradation of repository?

2062

How can you run a session without using server manager?

1 4470

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 4369

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?

2075

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to open an older version of an object in the workspace?

1272

Enterprise data warehouse your projects phase by phase explain?

1972

Differentiate between source qualifier and filter transformation?

1634

How to load data in informatica ?

1070

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

1109

What is a code page?

1221

What is meant by a domain?

1189

What are the types of caches in lookup? Explain them.

1015

what is informatica metadata?

1092

What is domain in terms of informatica?

1065

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

What is dynamic cache?

1087

How to update a particular record in target with out running whole workflow?

1635

What are the differences between oltp and olap?

1018

Slowly changing dimensions, types and where will you use them

1774

For More Un-Answered { Informatica } Questions Click Here