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

Informatica Interview Questions

Questions Answers Views Company eMail

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 3942

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 2594

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 4610

replace multiple spaces with single space.

IBM,

3 6516

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

CTS,

1 3716

Limitation of REPLACESTR. Is there any character limitation to it.

CTS,

1 4586

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

CTS,

2 5114

In development project what is the process to follow for an etl developer from day1

1724

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

L&T,

2 5060

The question was on time stamp. what is the difference between HH and HH24 when to use when.

Nationwide,

2057

Please let me know how to make Data masking in informatica..

1722

Please let me know how to make encryption and decryption with example?

1900

How can you join two tables without any common column present in them?

TCS,

1 3705

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1777

Explain your project of banking domian.

Cap Gemini,

1652

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can you validate all mappings in the repository simultaneously?

1371

what is informatica metadata?

1037

What is workflow? What are the components of the workflow manager?

1141

define galaxy repository in informatica

2228

Difference between Data and Index Caches?

1137

Describe the impact of several join conditions and join order in a joiner transformation?

1063

How do you convert single row from source into three rows into target?

1157

What is the need for an etl tool?

1068

What will be the approach?

979

What is the difference between a repository server and a powerhouse?

1513

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5792

How to load last n records of file into target table - informatica

1081

What is the benefit of partitioning a session?

1182

Explain why we use partitioning the session in informatica?

1093

tell me 5 session failure in real time how can you solve that in your project?

2304

For More Un-Answered { Informatica } Questions Click Here