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 8878

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

4 24857

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 5754

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

iGate,

2 6819

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

iGate,

1 6280

how to sort date field in infomatica?

2 6862

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 4952

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 }

What are the types of lookup transformation?

1077

What do mean by local and global repository?

1226

1932

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1795

is it possible to index the data in cache of lkp transformation ?

2029

What is update strategy transform?

1101

How can you validate all mappings in the repository simultaneously?

1369

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2357

Define sessions in informatica etl?

1034

expain about the tune parameters?

2414

How to open an older version of an object in the workspace?

1204

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

Write the unconnected lookup syntax?

1084

How you know when to use a static cache and dynamic cache in lookup transformation?

1854

can anyone explain me about retail domain project in informatica?

7946

For More Un-Answered { Informatica } Questions Click Here