Automagic Port Insertion into Expression (if I only knew earlier)

I just discovered that PowerCenter inserts a missing port into an expression by itself.


I had this expression where I had to calculate a big number of out ports. So I drag-and-dropped (dnded ;-) ) them to the expression and made them out ports only. After that I dnded the source ports to the expression but I did not get them all as it turned out.



After that I copied the calculations from my specification document into the expression field of the out port.



And the missing port was there as in port only.



It's magic, it's cool, I'm excited. I will see if I can remember and make use of this features.

ORA-01007 in PowerCenter though not in TOAD or the like

I recently got ORA-01007 after adding and forwarding ports of sources. I took the offending SQL from the session log and ran it in TOAD where it returned without errors.


Cause: I missed that the source qualifier used SQL override, so I did not adapt it.


Solution: I added the new ports to the attribute list of the SQL override and the error was gone.


N.b.: http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/ora01007-variable-not-in-select-list-1451528 says even that this error occurs when you do not strictly follow the order of the ports in the SQL override attribute list.

Worklet task instance [XYZ]: Could not acquire the execute lock for Worklet [xyz] [].

I just got this error. The Workflow Monitor showed the worklet in question as being succeeded.

Solution

Stop the worklet explicitly by the use of the context menu.
 It does not seem to be necessary to remove the lock in the Administration Console as suggested by https://kb.informatica.com/solution/5/Pages/18244.aspx