I got a error "Joiner Transformation has invalid join condition: not all of the ports could be found". while validating the workflow task
i just changed the join types to Detail outer joins from master outer joins and error disappeared and again i changed the join types back to Mater outer join and error did not occur.
Can some help me to figure out the reason for this error?
this is the best I could find from an old v5 troubleshooting doc.
CMN_1095 ERROR: Field name used in join not found in transform definition
Cause: The informatica Server could not locate a port specified in the Joiner transformation. You may have repository inconsistencies.
Action: Contact Informatica Technical Support
Sounds like chaning up the Join Type resolved your issue though.
Some times this may come changing port names in upstream and the propagation of ports to downstream, in mapping level we can change and save but in session level if we refresh it won't take modified port names on that time it will give above error. so, manually we have to modify join condition then session will valid.