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 8591

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 8880

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

4 24859

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 16518

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

1 5874

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

1 5757

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

iGate,

2 6822

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

iGate,

1 6282

how to sort date field in infomatica?

2 6863

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

1 4920

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 4953

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 15729

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17876

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

TCS,

2 9676

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

TCS,

2210

Post New Informatica Questions

Un-Answered Questions { Informatica }

Difference between Data and Index Caches?

1137

Is it possible to define a single node as a Gateway node as well as worker node?

1121

What is a surrogate key?

1080

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1064

How to configure mapping in informatica?

1173

Why sorter is an active transformation?

1191

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8118

Explain the types of lookup transformation?

1045

How many types of sessions are there in informatica.please explain them?

1166

Explain lookup transformation source types in informatica

1098

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

1979

What is data transformation manager process?

1156

Partition, what happens if the specified key range is shorter and longer

2499

can u any challenge your project?

2033

For More Un-Answered { Informatica } Questions Click Here