Please give me an approach to do upsert on small set of records.

[Anand KS]

Hi, I got an requirement like,

1)  Keep a LIST OF ALL CONTACT Id's that were processed in the file.  (called:  "CONTACTId_LIST)

2)  At the END OF THE ETL  --- after all the records have been upserted.

      a)   For each column "LOB"=VIVA  if the  contact Id is NOT in the CONTACTId_LIST then set column "membership" to inactive.

here, the issue is the table is already having huge records.

Could you please suggest what will be the best approach for this?

thanks

anand.

[Jeffrey Becker]

What database?

--
You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rhino-tools-d...@googlegroups.com.
To post to this group, send email to rhino-t...@googlegroups.com.
Visit this group at http://groups.google.com/group/rhino-tools-dev.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Anand KS]

mysql

[Jeffrey Becker]

Use an "insert on duplicate key update" statement