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 15411

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 9473

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 4527

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 4907

what is SDLC way of code development?

2042

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

Cap Gemini, CTS,

6 15337

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,

2720

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,

2131

What is the difference between Bulk Load and Normal Load

TCS,

3 13170

What is limitations of truncate and load option

Cap Gemini,

1 9964

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

Cap Gemini,

10 14347

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

Accenture,

4 9528

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

Accenture,

2 12854

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11535

What are the types of error logs available in Informatica?

1 6287

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many ways are there to create ports?

1330

What is the function of aggregator transformation?

1084

Explain your project of banking domian.

1652

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5790

Clarify the aggregator change?

1028

How to delete duplicate row using informatica?

1046

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2180

What are the different ways to implement parallel processing in informatica?

1423

How to extract sap data using informatica?

1042

What are the tuning techniques you applied during your last project

2025

difference between repository database and repository service?

1150

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

What are data-driven sessions?

1205

1932

What is a filter transformation?

1043

For More Un-Answered { Informatica } Questions Click Here