AnsweredAssumed Answered

Database lookup and Database join are driving me crazy

Question asked by B241Q6DO on Sep 12, 2018
Latest reply on Sep 14, 2018 by B241Q6DO

Hi,

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?

 

Max

Outcomes