Hi Team,
I have a requirement to load huge data (more than 5 lakhs)
I can load it using Integration or manually via excel, I would like to know what would be the best approach to load without impacting system performance.
I know regading switching off 'run business rules', 'auditing target table' and 'notifications'
Avoiding complex maniplations during transform in transform script .
these would improve load performance but I would like to know some good solution like pagination, batching , I know how to use pagination while sending data out but I am not sure on how to use pagination for incoming data also I think its not possible as data is not present in system .
Also how do I distribute load on all nodes equally ? is it automatically done by servicenow.
Is importing and transforming done seperately , like one after other ? can we make it simultaneously batch wise.
Please suggest
