I have TDP 3.8. I am trying to create a process to run a Oracle query based on a specific field within my Excel connection file and am not sure how to join.
Where [oracle field] =[Excel field]
I’ve attempted to do via a cross connection query but the Oracle query is very complex with many tables, joins and where conditions… Any guidance is appreciated! Thanks