For more information, please refer to this announcement explaining best practices for getting answers to questions.
Remove the empty block from Raw XML in Payroll Interface HCM extract - Global Payroll Interface V2
Summary:
We are facing challenges with the raw XML output file which is generating a huge size ~350MB. It is taking longer time almost 6 days to transform this raw XML by the BIP.
By doing the analysis, I identified that the raw XML for each employee size is almost 90KB which is expected to be less than 9KB. Further identified that the reason is because the raw XML is generating empty tags after the multi-threading DBI comparison.
I would like to know what is the way to remove these blank XML records so that we can reduce the file size for better performance. If we remove all the blanks then the file size would reduce to less than 40MB which will be easy for BIP to process and transform.