How to Print your Input and Output Query - Talend?
Printing your input query
If your result set isn’t as expected and you are struggling to understand why, then it is really useful to be able to see the query that was executed to give you the result. This recipe shows how this can be done.
Open the job jo_cook_ch07_0030_printInputQuery, which is a copy of the job from the previous recipe.