O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required