Hi everyone,can anyone explain error handling in informatica with examples so that it will be easy to explain the same in the interview.

Questions by vssaks   answers by vssaks

Showing Answers 1 - 9 of 9 Answers

go to the session log file there we will find the information regarding to the

session initiation process,

errors encountered.

load summary.

so by seeing the errors encountered during the session running, we can resolve the errors.

  Was this answer useful?  Yes

madhu

  • Feb 15th, 2006
 

You can create some generalized transformations to handle the errors and use them in your mapping. For example for data types create one generalized transformation and include in your mapping then you will know the errors where they are occuring.

  Was this answer useful?  Yes

Hemant Bhavsar

  • Apr 3rd, 2006
 

Also you can setup bad files and rejected files which you can use to see error records. There is a way also to reload bad/rejected records using information tools.

  Was this answer useful?  Yes

Error Handling
Sometimes a stored procedure returns a database error, such as “divide by zero” or “no more rows”. The final result of a database error during a stored procedure differs depending on when the stored procedure takes place and how the session is configured.

You can configure the session to either stop or continue running the session upon encountering a pre- or post-session stored procedure error. By default, the PowerCenter Server stops a session when a pre- or post-session stored procedure database error occurs.

  Was this answer useful?  Yes

Scenario in which when a load of 1000 records is loaded into the target and 100 records are bad records, those hundred goes to badfile dir which mention Session and the rest of the 900 should load to the target, I kept stop on errors as zero. But when I get even one error the session itself fails and rollbacks all the records.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions