I have a requirement to copy about 1 million records into a table based on lookup. To give you an overview, First, I am fetching all records that I need to copy (from source) and I am looking up if those records already exists based on a key column and based on those being available as updates/inserts I am doing a 'JDBC execute' using 'insert into select'. And the last 'JDBC execute' is taking huge amount of time to do that 'insert into select'. And then I thought of using 'JDBC Store' instead of 'JDBC Execute' But the problem is my target table is having identity columns and if I use JDBC Store node it says I am not passing a column's value to it (But that's how it should be because there's one auto-populating identity column that table).
How should I get past this and make use of the JDBC Store to see if it increases my performance?
Please sign in to leave a comment.