Wednesday 13 February 2013

Transformation errors In Informatica Workflows

While running Informatica workflow we may get Transformation errors.When the number of transformation errors are more it affects the speed of Informatica server because the server needs to go back and find the reason for the error and reject those records.As we know the transformation error can be of any type either Informatica mapping datatype mismatch,expression invalidation etc.In order to find the type of error we can check the session log and then change the mapping accordingly.

In some cases where there are many transformation errors coming we can set a lower tracing level and run the workflow but this is not feasible in all cases and is not a good solution.

Below is an example of transformation

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis