Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

Can we create out put ports in source qualifier t/r?

TCS,

5 15587

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

Cap Gemini,

5 9661

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 4620

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 4997

what is SDLC way of code development?

2097

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Cap Gemini, CTS,

6 15618

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

Cap Gemini, Cognizant,

2783

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

Bosch,

2175

What is the difference between Bulk Load and Normal Load

TCS,

3 13336

What is limitations of truncate and load option

Cap Gemini,

1 10047

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

Cap Gemini,

10 14706

Design a mapping to get year of join for each employee.

Accenture,

4 9669

Can we combine a flatfile and a database table using an UNION transformation?

Accenture,

2 12969

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11689

What are the types of error logs available in Informatica?

1 6377

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1847

how tokens will generate?

2249

Where can we find the throughput option in informatica?

1113

What is a shortcut and copy in Informatica and how two are different with each other?

1245

What is a standalone command task?

1257

What is the fact table?

1142

What are the new features of informatica 9.x at the developer level?

1110

What is dimensional table?

1135

What is an unconnected transformation?

1134

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3929

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350

what are the Methods For Creating Reusable Transformations?

1260

What do you mean by filter transformation?

1008

How to extract the informatica rejected data?

1260

How to extract sap data using informatica? What is abap? What are idocs?

1259

For More Un-Answered { Informatica } Questions Click Here