Difference
Diffrence operation takes two tables (current and previous versions of data) and computes difference between them comparing values of the columns. The input tables must have the same schema. You must specify Key columns that are used to find corresponding raws in the two input tables. You can optionally specify Ignore columns to be ignored during comparison. The target table will have the schema of the input tables extended with il_modification_status column that can have the following values:
new- record from the current table that is not presented in the previous table.updated- record presents in both tables and were updated.remove- record from the previous table that is not presented in the current table.
Last updated on