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 3935

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 2584

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 4604

replace multiple spaces with single space.

IBM,

3 6501

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 3709

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

CTS,

1 4583

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 5108

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

1718

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 5050

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

Nationwide,

2053

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

1711

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

1897

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

TCS,

1 3696

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

1773

Explain your project of banking domian.

Cap Gemini,

1650

Post New Informatica Questions

Un-Answered Questions { Informatica }

Mention few advantages of router transformation over filter transformation.

1021

Explain dynamic target flat file name generation in informatica

1045

what are the deliverables?in your project?

2150

What is the difference between Active and Passive transformation?

1149

update strategy transformation in informatica

1064

Have you worked with/created Parameter file

1660

wf dont have integration severances how you can run?

1938

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2146

How can we delete duplicate rows from flat files?

1218

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1259

What do you mean by blocking transformation?

1033

Explain the shared cache and re-cache?

1111

Explain sessions. Explain how batches are used to combine executions?

1026

Why is sorter an active transformation?

1125

What is workflow monitor?

1058

For More Un-Answered { Informatica } Questions Click Here