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 15256

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

CTS,

5 11093

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 8377

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

1 4106

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

Accenture,

5 23917

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

Accenture,

4 17870

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20903

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 12004

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

Deloitte, IBM, iGate,

11 41731

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 22178

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 24818

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 9463

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

1 4657

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

2265

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

2 7969

Post New Informatica Questions

Un-Answered Questions { Informatica }

can we override a native sql query within informatica? Where do we do it? How do we do it?

1115

Can we override a native sql query within informatica?

1094

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

2204

What is joiner transformation?

1067

What differs when we choose the sorted input for aggregator transformation?

1076

In informatics server which files are created during the session rums?

1171

How we can create indexes after completing the loan process?

1253

How to configure mapping in informatica?

1226

Plz can any one say me how to get the informatica certification materials and dumps

2105

What is a code page?

1223

Is it possible to create multiple domains on a single Informatica server?

1291

How many dimensions are there in informatica?

1139

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2360

Under what condition selecting sorted input in aggregator may fail the session?

1177

where to store informatica rejected data?

1141

For More Un-Answered { Informatica } Questions Click Here