I'm wondering what option I have when I want to enable concurrent importing from a DB2 connection where I have written a custom query. Basically it is a FULL OUTER JOIN between two tables containing the same but opposite variables (one is for online usage by customers by month and the other is offline usage). I use COALESCE to combine the customer keys and the time keys in the Custom SQL, and I would like to enable concurrent importing by the combined time key from both tables.
My solution was to put this into a sub query and SELECT * from that sub-query and put the time key in $$. This runs, but at the end of the job all records fail.
Am I doing something wrong? Is there another way of doing this? (without splitting it up into two tasks)
Thanks in advance
Please sign in to leave a comment.