SAC duplicating random entires and drop the same to intact total entries.
The number of entries did not get duplicated at CDS view Level and the same while creating the SAC model as both entries matched and showed the same at import results however analyzing data shows SAC manage to duplicate some rows and drop some on its own and still number of entries remain intact.
This abnormal behavior was observed while loading data at PRD but didn't face any such at DEV however PRD has around 220k entries and DEV has greater 240k entries.
This gets resolved at PRD when uploading in chunks of 5/10 days of data.