How do you do error handling in Informatica?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we improve session performance in aggregator transformation?

876


-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?

5339


What is informatica worklet?

785


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

1146


How to create Target definition for flat files?

977


What is DR strategy for Informatica project?

900


Why update strategy and union transformations are active?

799


which one is better performance wise joiner or look up

830


What are Dimensional table?

796


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1005


What happens when a session fails and you click on recover?

850


What is the surrogate key?

848


Write the prerequisite tasks to achieve the session partition?

831


Why filter transformation is an active one?

756


How many input parameters can exist in an unconnected lookup?

1271