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

1763

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 2842

What are the parts of Informatica Server?

Cognizant,

1 3365

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

1 3981

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 3474

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

1 3400

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

1 3219

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

Cognizant,

2456

How do you do error handling in Informatica?

1 7971

How do you implement scheduling in Informatica?

1 3649

What is the meaning of up gradation of repository?

1910

How can you run a session without using server manager?

1 4239

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 4135

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?

1988

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the different lookup cache(s)?

1043

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7336

permutations of mapplet

2465

Can we change Dynamic to Static or Persistent cache? If so what happens?

2158

When do you use sql override in a lookup transformation?

1035

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

927

What is repository manager?

940

What is the status code in stored procedure transformation?

1131

Explain the aggregator transformation?

1102

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

992

Explain load alternative records / rows into multiple targets - informatica

1110

Different circumstance which drives informatica server to expel records?

933

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1954

wf dont have integration severances how you can run?

1889

I have a flat file, want to reverse the contents of the flat file

1073

For More Un-Answered { Informatica } Questions Click Here