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 8674

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 9032

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

4 25018

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 16625

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

1 5947

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

1 5850

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

iGate,

2 6942

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

iGate,

1 6363

how to sort date field in infomatica?

2 6994

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

1 4994

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 5078

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 15917

What are the challenges you have faced in your project?

Cognizant, Infosys,

1 17970

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

TCS,

2 9803

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

TCS,

2262

Post New Informatica Questions

Un-Answered Questions { Informatica }

define galaxy repository in informatica

2293

Explain transaction control transformation in informatica

1312

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2251

What is a sorter transformation?

1160

what is informatica metadata?

1092

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

2558

waht type of interface is used for testing the data in informatica

2302

draw informatica architecture 8.6 ?

3933

What is enterprise data warehousing?

1108

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

1188

What is native users?

1227

What are the performance considerations when working with aggregator transformation?

1213

How do you handle two sessions in Informatica

1221

Enlist the various types of transformations.

1125

Explain pushdown optimization $pushdownconfig parameter - informatica

1197

For More Un-Answered { Informatica } Questions Click Here