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?

682


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

630


Explain the use of aggregator cache file?

693


Is it possible to create multiple domains on a single Informatica server?

762


explan ur project architecture?

1605






In warehouses how many schemas are there?

594


How do you remove duplicate records in informatica? And how many ways are there to do it?

725


What is expression transformation?

642


what is the Default Source Option For Update Strategy Transformation?

768


What are the differences between joiner transformation and source qualifier transformation?

636


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1802


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1633


What is enterprise data warehousing?

621


What are the guidelines to be followed while using union transformation?

648


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

1599