I have a transformation where I use a database lookup or database join step to look up a value from my database. The problem is: it does not find the record in my table! I am 100 % sure it is there and if I run the SQL in another editor it returns the result but not from PDI.
When I run the same SQL in a table input step, it returns the correct result.
Is there a way for me to check what SQL exactly the database lookup or database join steps are sending to the server (besides checking on the server itself). If I change the logging to detailed or debugging I just get the SQL statement with the ? but not what is send to the server.
Any ideas how to troubleshoot this?