Removing records via a Migration Job normally uses the Remove__ method, which requires Objkey and ObjVersion values — but when the source data is a plain CSV file, Get_Rowkey can find the Rowkey, while there's no equivalent function to get the current RowVersion for a record to remove. How is this handled?

All FAQ questions / Data migration

Answer

Join the migration job's IC (Import/Convert) staging table against the actual target table/view on the shared unique business-key columns from your CSV data — for example, matching the staging table's key columns to the corresponding key columns on the real table lets a straightforward SQL join pull back that record's current ROWVERSION (and ROWID) directly, giving you the value Remove__ needs without relying on a dedicated RowVersion lookup function that doesn't exist for this purpose.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Data migration questions