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 14931

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

CTS,

5 10865

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 8290

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

1 4031

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

Accenture,

5 23727

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

Accenture,

4 17677

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20668

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 11791

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

Deloitte, IBM, iGate,

11 41232

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 22086

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 24559

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 9345

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

1 4567

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

2168

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

2 7866

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is expression transformation?

1099

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

have u done any performance tuning? how u ll do?

2299

how we can load rejected record's at run time?(not through bad files)

2379

What is a filter transformation and why it is an active one?

968

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395

What is meant by lookup transformation? Explain the types of lookup transformation?

948

what is the -ve test case in your project.

2407

How to load the data from people soft hrm to people soft erm using informatica?

1011

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

what is the size of your data warehousing?

2095

What can we do to improve the performance of informatica aggregator transformation?

1093

How to do the error handling of if ur source is flatfiles?

1968

How to generate sequence numbers?

1087

What is the advantage of informatica?

1069

For More Un-Answered { Informatica } Questions Click Here