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 3822

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 2518

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 4531

replace multiple spaces with single space.

IBM,

3 6351

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 3627

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

CTS,

1 4511

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 5016

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

1656

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 4932

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

Nationwide,

2000

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

1667

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

1852

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

TCS,

1 3616

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

1732

Explain your project of banking domian.

Cap Gemini,

1615

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is the -ve test case in your project.

2337

What are the uses of etl tools?

1072

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2357

What is a repository manager?

1036

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

1851

How does a rank transform differ from aggregator transform functions max and min?

1147

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1052

what is index?how it can work in informatica

1984

What is the difference between Active and Passive transformation?

1086

How many number of sessions can one group in batches?

1100

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2125

What is the need for an etl tool?

1015

Write the prerequisite tasks to achieve the session partition?

1078

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

1138

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7324

For More Un-Answered { Informatica } Questions Click Here