How do you do error handling in Informatica?



How do you do error handling in Informatica?..

Answer / kishore

Mainly  errors were like null values first we need to process error records into one target and good record into another target by using router transformation.after execution of mapping we check the error file size through unix if error file size is greater than 0 then we will send email to source system team with error file attachments. 

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

how many types of dimensions are available in informatica?

0 Answers  


What are the various types of transformation?

0 Answers  


hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  


if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,






I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  


How many number of sessions can one group in batches?

0 Answers  


How can one identify whether mapping is correct or not without connecting session?

0 Answers  


What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,


How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,


How to jion 2 tables, without using any condition?

11 Answers   Amazon,


How we can create indexes after completing the load process?

0 Answers  


Categories