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 3826

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 2521

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 4533

replace multiple spaces with single space.

IBM,

3 6356

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 3632

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

CTS,

1 4515

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 5018

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

1659

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 4936

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

Nationwide,

2002

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

1669

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

1860

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

TCS,

1 3619

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

1734

Explain your project of banking domian.

Cap Gemini,

1617

Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you migrate data from one environment to another?

1053

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1979

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2231

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?

1013

How many transformations can be used in mapplets.

1883

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1585

Which transformation is needed while using the Cobol sources as source definitions?

1132

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

1991

Explain Dataware house architecture .how data flow from intial to end?

2540

Implementation methodology

1659

What is target designer and target load order?

1057

generate date / time dimension in informatica

1075

What is a node in Informatica?

1008

What is workflow manager?

996

What is the sql query overwrite in source qualifier in informatica

1031

For More Un-Answered { Informatica } Questions Click Here