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 3939

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 2592

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 4609

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 3713

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 5112

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,

2055

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 }

What is status code in informatica?

1019

How do you load first and last records into target table?

1159

what is diff b/t sorter t/r and agg have the option sorter property...

2171

Which files are created during the session rums by informatics server?

1179

What is Data Caches size?

1091

Difference between Data and Index Caches?

1137

How we can create indexes after completing the load process?

1160

What is rank index in rank transformation?

1079

Differentiate between joiner and lookup transformation?

1102

What is a standalone command task?

1204

generate date / time dimension in informatica

1125

Define pmcmd command?

1040

Why filter transformation is an active one?

983

In warehouses how many schemas are there?

1073

What are the different versions of informatica?

1272

For More Un-Answered { Informatica } Questions Click Here