Troubleshooting Informatica Error Messages and Resolution – Part 25
Validating the Join Condition
<Hierarchy>: Source is an SAP InfoHierarchy and cannot be used in Join Override.
Cause:You included a hierarchy in the join override in the Application Source Qualifier.
Action:Remove the hierarchy from the join override condition.
In Application Source Qualifier <Application Source Qualifier name> no join exists between tables <sourceX> and <sourceY>.
Cause:You specified a join condition for two source tables but you did not specify the join type between the two tables.
Action:Specify the join type between the two tables in the Join Type tab.
In Join Condition expression for <Application Source Qualifier name>: <condition>; <table name> can only appear on the value side or right side of a relational operator for source table join order <table join order>.
Cause:The qualifying table in the join condition is not selected before all other tables in the condition are selected. For example, with a join order S1, S2 you may have entered a join condition S1 = S2.
Action:Make sure that the qualifying table appears in the join order before all other tables in the condition. For example, if the join order is S1, S2 the override must be S2 = S1.
In join condition for <Application Source Qualifier name>: <join condition>; <token>: constant or literal has to follow an operator.
Cause:You cannot have a space in an operator, such as < =.
Action:Edit the join condition and remove the space from the operator.
In join condition for <Application Source Qualifier name>: <join condition >; <sourceX> refers to a source table which follows <sourceY> in a source table join order of <join order>.
Cause:The outer most table in the join condition is not used as the qualifying table.
Action:Either change the order of the join condition or change the qualifying table so that the outer most table in the join condition is used as the qualifying table. For example, if the join order is S1, S2, S3, you can have a join override
S3 = S3 = S2 = S1 or S2 = S2 = S1.
No condition exists between tables <sourceX> and <sourceY>.
Cause:You tried to join two source tables that have no key relationship.
Action:Specify a key relationship between the two tables in the Join Condition tab.
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.
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.