AnsweredAssumed Answered

Database lookup and Database join are driving me crazy

Question asked by B241Q6DO on Sep 12, 2018
Latest reply on Sep 21, 2018 by Alain Debecker


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?