Just have a quick question. First time using the modify data through CSV tool in the database and I am curious if there is hard limit where I should not exceed.
For example, should I do it in batches of 10,000 records? Am I able to bring it up more? Just wanting to hear the community’s thoughts on it.
Thanks!
It still does consume workload units. Is this a one time thing or you are looking to do this frequently?
Not worried about the WU with it. Here’s the situation:
Need to add a field with data to over 500,000+ records. Determined that modify data through CSV is my best option. I’m just curious if I can run the 500,000 record CSV or should I break it up into chunks? And if I break it up, how many should I do?
I would probably break it up. Maybe into 5, 100k files. That way if the file does have an issue you have a decent place to start.
Would be annoying to try and find where the file modify failed and have to redo the whole file.
