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

1814

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

1833

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

1 2910

What are the parts of Informatica Server?

Cognizant,

1 3450

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

1 4074

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 3563

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

1 3468

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

1 3294

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

Cognizant,

2557

How do you do error handling in Informatica?

1 8046

How do you implement scheduling in Informatica?

1 3745

What is the meaning of up gradation of repository?

1980

How can you run a session without using server manager?

1 4363

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 4239

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?

2024

Post New Informatica Questions

Un-Answered Questions { Informatica }

Whats there in global repository

1690

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

1199

How can we store previous session logs?

1068

what is mean by complex business rule ?

2156

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2856

Which development components of informatica have the highest usage?

1033

What are the static cache and dynamic cache in informatica?

1182

What is an unconnected transformation?

1080

Can you generate sequence numbers without using the sequence generator transformation?

1117

Under which circumstances, informatica server creates reject files?

1086

While migrating the data from one environment to another environment how would you manage the connections?

1086

On which transformations you created partitions in your project?

1342

How to configure mapping in informatica?

1173

What is the maplet?

1112

How is union transformation utilized?

1005

For More Un-Answered { Informatica } Questions Click Here