Data360 Analyze

Hi Team,

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?

This issue is being progressed using a support ticket.

#80272

May i know how can i track progress of that ticket, as i am not sure if there is some place where i can go and see progress based on ticket number?

Hi Yashvanth,

If you log into our support website https://support.infogix.com/hc/en-us hit the dropdown next to your name and select My Activities you will be able to see the ticket. I am more than happy to do a support website overview if you are interested.

Thank you,

Brenda Stoetzer, Support Relationship Manager 

Hey Brenda, Thanks for that. 

Actually, for the same issue, I had two questions related to two different approaches that I am trying. Like one approach with JDBC execute with slowness and JDBC Store with identity columns handling. 

Can we track both of these individually to get updates accordingly? Below are the two things I wanted to get answers for,

https://support.infogix.com/hc/en-us/community/posts/360037433134-How-to-use-JDBC-Store-on-tables-with-Identity-Columns-?page=1

https://support.infogix.com/hc/en-us/requests/80272