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 3044

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 1931

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 3787

replace multiple spaces with single space.

IBM,

3 5203

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 2899

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

CTS,

1 3628

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 4086

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

1259

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 3930

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

Nationwide,

1522

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

1240

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

1426

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

TCS,

1 2889

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

1310

Explain your project of banking domian.

Cap Gemini,

1194


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the features of complex mapping?

617


What are active transformations.

1160


What are the tasks that can be performed using sq?

590


Can you generate sequence numbers without using the sequence generator transformation?

576


tell me 5 session failure in real time how can you solve that in your project?

1606






Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6295


Explain incremental aggregation in informatica

630


Explain how many types of dimensions are available in informatica?

562


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1891


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1511


How you prepared reports for OLAP?

1122


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

1538


While importing the relational source definition from the database, what are the metadata of source that will be imported?

755


What is meant by lookup transformation? Explain the types of lookup transformation?

545


Explain the different lookup methods used in informatica?

562