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.
Solved! Go to Solution.
So it appears that it is case sensitive. Didn't realizing my Dynamic Input In-DB name was all caps. Once I fixed that it worked.