Troubleshooting Informatica Error Messages and Resolution – Part 395


TT_11091ERROR: The control expression of a Transaction Control Transformation <transformation name> is evaluated to <evaluated value>.
Cause:The transaction control expression in a Transaction Control transformation evaluated to an invalid value. When the transaction control expression evaluates to any value other than continue, commit, or rollback, the Integration Service fails the session.
Action:Edit the transaction control expression so that it does not evaluate to an invalid value.

TT_11099Fatal Error: Joiner <transformation name> join condition cannot contain binary ports.
Cause:The join condition for the named Joiner transformation contains a binary port.
Action:Remove the binary port from the join condition in the Joiner transformation.
TT_11100Fatal Error: Joiner <transformation name> input not sorted. Current row’s key = <key value>.
Cause:The named Joiner transformation is configured to use sorted input, but the Joiner transformation received unsorted data.
Action:Edit the Joiner transformation to use unsorted input.
Action:Verify that the session and mapping properties maintain sort order between the sorted data and the Joiner transformation.
In the mapping, verify that the columns in the join condition match the columns of the sorted data and that the mapping does not contain active transformations between the sorted data and the Joiner transformation.
In the session, verify that the partitioning properties maintain sort order between the sorted data and the Joiner transformation.

TT_11118The cache directory specified for transformation [transformation name] is empty. A valid directory must be specified.
Cause:You did not specify a cache directory for the Lookup transformation.
Action:Edit the session properties and specify a lookup cache directory.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *