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 6512

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 4585

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 5113

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 5059

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..

1721

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 3704

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

1776

Explain your project of banking domian.

Cap Gemini,

1652

Post New Informatica Questions

Un-Answered Questions { Informatica }

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2261

What are the uses of etl tools?

1128

What are the different ways to implement parallel processing in informatica?

1423

What is domain and gateway node?

1165

How can we use mapping variables in informatica?

1063

permutations of mapplet

2511

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

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

1064

What is the benefit of partitioning a session?

1182

What are the performance considerations when working with aggregator transformation?

1152

Explain informatica architecture - version 8 / 9

1089

Explain incremental aggregation in informatica

1130

Could you explain what is enterprise data warehouse?

1148

For More Un-Answered { Informatica } Questions Click Here