Workflow: Session Error Logging and Reporting
Posted by: Anupam Shrivastava
Enable error logging of your PowerCenter session and fetch metadata of the erroneous records.
Overview
PowerCenter developers often run in to scenarios where sessions fail for number of reasons. One of the most popular scenarios is sessions failing because of bad quality of data. You can enable database error logging for all the ETL jobs running on Informatica Power Center. However, the challenge is to view the error records along with their metadata (Folder Name, Workflow Name, Session Name, Mapping Name, Transformation name, Transformation Column name or port name) from this centralized repository. The solution provided here helps you in following way:
- Helps create error file with respect to each transformation within Informatica session.
- Helps you monitor any data quality issues.
- Helps in debugging any transformation errors in Informatica mappings.
- Helps you monitor the error records and provide corrections to existing ETL mapping to avoid these rejections on daily basis. This in turn will provide ongoing process improvements.
- Provides visibility to Business and IT Analysts about the bad data or incorrect business logic in ETL mappings.
Features
Error Handling (Error Logging and Creating Error Reports) from centralized repository reduces the ETL development life cycle by increasing the productivity. It will provide Business values by resolving data quality issues.Can be used in any project having Informatica as Data Integration tool.- PowerCenter version: 9.x
