Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2321

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 1452

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 2722

replace multiple spaces with single space.

IBM,

3 3496

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 2193

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

CTS,

1 2618

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 3143

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

832

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 2679

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

Nationwide,

1069

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

883

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

815

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

TCS,

1 1961

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

918

Explain your project of banking domian.

Cap Gemini,

807


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is native users?

254


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

1069


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

207


Explian the Process of deployment groups in informatica

252


What is the format of informatica objects in a repository?

214






How can you validate all mappings in the repository simultaneously?

267


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1002


What is the benefit of partitioning a session?

242


What is transformation?

205


what is the size of your data warehousing?

1255


What is an active transformation?

261


Which transformation should we use to normalise the COBOL and relational sources?

272


Different circumstance which drives informatica server to expel records?

197


What is mapping debugger?

226


What is the session task and command task?

233