Troubleshooting Informatica Error Messages and Resolution – Part 79


CMN_1099ERROR: Master and detail relations are flipped from user specification.
Cause:In the mapping, one Source Qualifier transformation has been linked to two Joiner transformations in the same target load order group, and has been specified as the master source in one Joiner transformation and the detail source in the other.
Action:Edit the Joiner transformations so the same Source Qualifier transformation is the master source in both Joiner transformations in the same target load order group.
Action:If you need to keep the Source Qualifier transformation as the master source in one Joiner transformation and the detail source in the other, create a separate target load order group and place one of the Joiner transformations in that second group.

CMN_1100ERROR: A target load order group has at least one Source Qualifier transformation that has been used to provide master as well as detail data.
Same as CMN_1099.
CMN_1101ERROR: Alter the mapping and place the target tables violating this constraint in different target load order groups.
Same as CMN_1099.
CMN_1102ERROR: No ports in the join condition are connected.
Cause:Internal error.
Action:Contact Informatica Technical Support.

CMN_1103WARNING: No row found from the master relation. Joiner will not produce any output row.
Cause:The master source contained no rows. Since the data from the master source is read before the detail source data can load, the Joiner transformation is unable to produce data when the master source contains no data.
Action:Make sure the correct source tables are named in the mapping and those tables contain data.
CMN_1104ERROR: The conversion from source type to target type is not supported.
Cause:The mapping contains an invalid datatype conversion.
Action:In the Designer, validate the mapping to locate the invalid conversion.

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 *