1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 3065

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 1954

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 3818

replace multiple spaces with single space.

IBM,

3 5235

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 2921

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

CTS,

1 3666

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 4121

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

 1268

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 3956

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

Nationwide,

1540

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

 1255

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

 1451

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

TCS,

1 2906

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

 1322

Explain your project of banking domian.

Cap Gemini,

1208

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a grid in Informatica?

599

How you know when to use a static cache and dynamic cache in lookup transformation?

1327

lookup transformation with screenshots

3546

How to implement security measures using repository manager?

588

Differentiate between a repository server and a powerhouse?

565




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

1555

What is target designer and target load order?

645

Describe the impact of several join conditions and join order in a joiner transformation?

631

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1661

What are Dimensional table?

599

What is dimensional table?

611

complex mapping ur project u r invlve can u explain and give real time example give me ?

1832

Which version configuration tool used in ur project?

2758

Enlist some properties of sessions.

609

What are junk dimensions?

622

For More Un-Answered { Informatica } Questions Click Here