If I have a table with keys defined and primary key enforcement turned on how does Incorta ingest and process duplicate rows? First in wins? Last one in wins? Other?
If a duplicate(s) is found during an incremental update does the existing Incorta record get updated in the same fashion ( i.e. if there are two duplicates in the incremental load does the existing record get updated with the first "new" record in or the last ) ?
I think I understand that incremental loads create their own parquet file - is the order of operations 1) full load creates temp file, goes through compaction and dedup, and then creates final file, 2) incremental load creates temp file, goes through compaction and dedup, and final file, and then 3) original and subsequent incremental files are read into memory w/ further dedup in chrono/file order?