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

Informatica Interview Questions

Questions Answers Views Company eMail

How will you update the row without using update statergy?

CTS,

10 14674

How will you update the first four rows and insert next four rows in a mapping?

CTS,

5 10653

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

Wipro,

1 8215

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 3959

how to join the 2 different table with different columns in informatica?

Accenture,

5 23587

How to load the source table into flat file target(with columns) in informatica?

Accenture,

4 17524

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20490

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 11634

How we can get unique records into one target table and duplicate records into another target table??

Deloitte, IBM, iGate,

11 40827

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

1 22009

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 24344

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 9217

hi all, Can anyone please tell me the relationship between informatica and business objects

1 4474

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2097

How to load duplicate records in to a target table which has a primary key?

2 7774

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is workflow monitor?

1013

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2016

Explain sql transformation in script mode examples in informatica

1074

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2116

What is a rank transform?

1048

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2522

Can we get 1st record through Informatica(without sequence number).

1431

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1857

What is workflow? What are the components of workflow manager?

1136

How to do unit testing in informatica?

1137

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1082

What is informatica powercenter repository?

1154

Scheduling properties,whats the default (sequential)

1914

Explain constraint based loading in informatica

1055

explain about unit testing? in real time?

2157

For More Un-Answered { Informatica } Questions Click Here