INFORMATICA ERRORS

What are the Types of Errors in Informatica Power Center?

·         Fatal Errors

·         Non Fatal Errors

What are Fatal Errors?

Fatal errors are those which occur when Integration service cannot access the source, target or repository.

List a few common Fatal Errors?

·         Loss of connection to databases.

·         Target database errors, such as lack of database space to load data.

·         If the session uses a Normalizer or Sequence Generator transformation, the Integration Service cannot update the sequence values in the repository, and a fatal error occurs.

What happens in the following scenario?

A Session which doesn’t have Normalizer or Sequence Generator transformation is loading data to the Target, connection to the Repository got lost,

Will the session stop?

No, the session doesn’t stop it completes successfully.

What are the Impacts?

The session completes, but the Integration Service cannot log session statistics into the repository.

What are Non Fatal Errors?

A Non fatal Error is an error that stops the session based on the error threshold value configured.

Where and how to configure this Error Threshold value?

Error threshold is the value which is configured at the session level with the Stop on Errors option.

Right click your session > Edit > Config object tab.

 What if we configure the value to '0'?

The Integration service does not stop the session when it encounters non fatal errors.

By default the value for Error Threshold is '0'

 What happens when this value is configured?

Integration service counts the non fatal errors that occur at the Reader, Writer and Transformation threads.

 What are non fatal Reader errors?

Errors encountered by the Integration Service while reading the source database or source files.

What are non fatal writer errors?

Errors encountered by the Integration Service while writing to the target database or target files.

List some of the common non fatal writer errors?

·         Key constraint violations.

·         Loading nulls into a not null field.

·         Databases trigger responses.

What are Transformation errors?

Transformation errors are those which Integration service encounters while transforming data.

List some of the common non fatal writer errors?

·         Data type conversion errors.

·         When Error Function in configured in the transformation to handle null input.