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

Informatica Interview Questions

Questions Answers Views Company eMail

How to eliminate duplicate records in informatica mapping? Explain with an example....

Cap Gemini,

1 8521

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

3 8767

Using Expression transformation how to remove duplicate records from a relational source?

4 24691

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

Cap Gemini,

1 16430

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 5803

plz plz plz send client names and project names in informatica?

1 5680

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

iGate,

2 6721

how we can do session partition in informatica any one explain me clearly? thanks advance.

iGate,

1 6202

how to sort date field in infomatica?

2 6751

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 4833

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 4854

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 15527

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17789

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

TCS,

2 9583

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

TCS,

2162

Post New Informatica Questions

Un-Answered Questions { Informatica }

Differentiate between sessions and batches?

976

what are the deliverables?in your project?

2102

How would you join a node to the already existing domain?

1083

Implementation methodology

1663

What is resilience time?

1064

Briefly explain the aggregator transformation?

956

What is status code in informatica?

976

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

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 a mapplet/worklet in informatica?

1138

How can we use mapping variables in informatica?

1019

What is meant by LDAP users?

1133

What is joiner transformation?

965

What do you mean by channel change?

986

What is source qualifier transformation in informatica?

960

For More Un-Answered { Informatica } Questions Click Here