Using the Table_Comparison transform

The Table_Comparison transform compares a dataset generated inside a dataflow to a target table dataset and changes the statuses of data set rows to different types according to the conditions specified in the Table_Comparison transform.

Data Services uses primary key values for the row comparison and marks the passing row accordingly as: an insert row, which does not exist in the target table yet; an update row, the row for which primary key values exist in the target table but whose non-primary key fields (or comparison fields) have different values; and finally, a delete row (when the target dataset has rows with primary key values that do not exist in the source data set generated inside a dataflow). In ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.