So I'm testing performance and I'm having issues with the In-DB portion. I was able to run everything and it took 1.5 hours in total without using any In-DB tools. Now I'm trying to do a portion of the work In-DB and see if it cuts down on runtime.
I'm getting an error for a join: left and right side must have the same in-db connection.
My left input to the join comes from a dynamic input tool where the connection is New Server.
My right input to the join is a local file I'm using data stream in and creating a temporary file with the connection name new server. I've tried to rename it so that its New Server and still getting issues with this error.