Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Using chunk size and threading to improve the Historical Assignment hcm extract performance issue
Summary:
I have created an HCM Extract for assignment that retrieves historical data for employees. There is no date filter, it picks up past, future and present.There are 144567 employees that it retrieves in the baseline file and it is taking 1 hour 30 min to run even when we run for incremental loads using the changes only parameter.
To improve the performance I used the process configuration group and made the following changes -
Now it is completing in 60 min. What should be the most optimal value that i pass in chunk size and thread so that this process runs undr 30 min.
Tagged:
0