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 15256

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 9321

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 4458

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 4815

what is SDLC way of code development?

1983

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

Cap Gemini, CTS,

6 15109

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,

2688

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,

2089

What is the difference between Bulk Load and Normal Load

TCS,

3 13019

What is limitations of truncate and load option

Cap Gemini,

1 9879

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

Cap Gemini,

10 14101

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

Accenture,

4 9369

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

Accenture,

2 12745

Difference between STOP & ABORT in Informatica.

Accenture, Wells Fargo,

3 11396

What are the types of error logs available in Informatica?

1 6200

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1908

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5592

What is rank transformation?

943

What is union transformation in informatica?

1105

What is informatica etl tool?

959

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

1023

How do you take back up of repository?

1108

What are the modules in Power Center

1639

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

2315

What does update strategy mean, and what are the different option of it?

1057

What does reusable transformation mean?

1086

What is an expression transformation?

980

Tell me about MD5 functions in informatica

887

What are the different lookup cache(s)?

1048

What is the difference between stop and abort in informatica

1055

For More Un-Answered { Informatica } Questions Click Here