3630590 - Employee Import Job Processing is Slow and Takes a While to Finish

• Employee Import job takes a long time or is taking longer than usual (about an hour)
• Sudden increase of the processing time to complete the Employee Import

SAP SuccessFactors HCM

1. Schedule an employee import job in SAP SuccessFactors.
2. Observe the duration of the import process in Scheduled Job manager. It takes about 45 mins to more than an hour to finish.

The action causing the delay is the load data from CSV file and comparing the hash value between CSV file and database data.

There are two main factors that can affect the processing time of the Employee Import:

1. The data size of the Import file. If the job suddenly took more time than usual, then it's possible that the new import file has more data in it
2. The second one is that the system is loading and comparing the data (hash value) between the CSV File and the data in the database. This is the process that can cause confusion with the customers as there is an understanding that Delta Import would take effect and that a few additional data in the CSV file should only take a few minutes to complete. The understanding is that the job should complete faster after every import (since most data should already be in the database). 
   
   However, even if the import itself would be faster as some of the data is already loaded before, the action to load, compare and check the data in CSV and what the database currently have will take some time to finish. This process can take most of the job's run time.

2449342 - Troubleshooting Employee Import issues - Guided Answer

2824200 - Delta mode is now enabled in Employee Import and Basic Import

employee import, slow processing, sap successfactors, csv file, hash value comparison, data import duration, import job, user profile update, import, delay, INC13267398 , KBA , LOD-SF-PLT-UIM , Employee Import Issues , Problem