How to handle errors in informatica?

·        We have one of the source with numerator and denominator values we need to calculate num/deno

·        When populating to target.

·        If deno=0 I should not load this record into target table.

·        We need to send those records to flat file after completion of 1^st session run. Shell script will check the file size.

·        If the file size is greater than zero then it will send email notification to source system POC (point of contact) along with deno zero record file and appropriate email subject and body.

·        If file size<=0 that means there is no records in flat file. In this case shell script will not send any email notification.

·        Or

·        We are expecting a not null value for one of the source column.

·        If it is null that means it is a error record.

We can use the above approach for error handling.