An AutoIndex job is configured to update a field in a File Cabinet (Cabinet A) based on a match in the source, also a file cabinet (Cabinet B). The source is the shorter list so it is the first read. Both file cabinets have numerous records and the job takes a long time to complete.
To shorten the time the configuration is filtering the source, Cabinet B, on a field value. There are multiple matches in Cabinet A for each record in Cabinet B. The write back updates the same field in Cabinet B that is used for the filter to prepare for the next run.
Can I assume that the write back will occur after all of the matches in Cabinet A are found and updated? If the write back occurs after the first match is found, would that filter out the record in the source Cabinet so that the remaining matches would be skipped?
Thanks,