best practise to bulk upload over 100000 records to a table

[Vasudhevan2]

Hi All,

I have a requirement to upload more than 100000 records into incident table with incident number as unique value and update another field. only these two fields are needed to be there on the template. I would like to get your expert opinion on the best way to achieve this.  if import set is the option is there any limit that I should mention on the number of entries per import?

[Bhuvan]

@Vasudhevan2 

Did you get a chance to review this as I believe the information provided should answer your question

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan