I am using IDQ 9.6.1
I have a simple mapping with source --> expression --> update strategy (DD_UPDATE) --> target. I have about ~1 million records. When I run the mapping, it doesn't update all the records (Affected Rows: 9999 Applied Rows: 8242). But when I filter the records to only include less than 2000 records, all the records update.
Also, If I run the mapping multiple times for 1 million records; for each run I only pick the only records that didn't get processed earlier, eventually, all the records get processed.
Where should I look? Anything to do with buffer?
Moving to Data Quality Community