1 Reply Latest reply on Dec 7, 2017 1:55 AM by Neeraj Upadhyay

    IDQ only updating partial records

    Hari Munikar New Member

      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?