I'm having a difficult time resolving a red "invalid" icon within Informatica. I've done all possible scenarios for checking in / checking out this object (mapping). It currently does not have any dependencies. How can I fix this?
-
When you validate the mapping, are there any errors in the Validate tab of the output window (at the bottom)?– Marek GrzenkowiczJan 30, 2014 at 7:44
-
1This was due to an incomplete mapping because my expression transformation didn't have output ports (only input ports) just before the target definition.– JustBeingHelpfulJan 30, 2014 at 19:41
2 Answers
This was due to an incomplete mapping because my expression transformation didn't have output ports (only input ports) just before the target definition.
-
What if the exchange only happens on the inbound? Do we still need to seetup an out port?– user68344Jun 11, 2015 at 15:59
-
That's a great question. I didn't receive the error in that use case. My issue happened when a target definition was created. Are you getting this error on a source definition our something else (different object type)? Jun 12, 2015 at 0:21
I would like to had a general guide to debugging "invalid" object in PowerCenter.
Indeed as the debugger from the PowerCenter Workflow does not run on invalid Mapping(I would say in general does not run on invalid objects), the only way to get more information is to go on the repository Manager and follow this steps:
Open the specific folder
Right-click on the object and try before to refresh( this will make sure any change not saved will be saved), then choose "Validate", at this point teh Repository Manager will try to validate the object otherwise finnally you will get an error message reporting what is causing the invalidation.