How to Use the Table Compare Transform in SAP Data Services
Following the previous series of creating a job that pulls data from a flat file source and writes it into a table in the database. This video adds a table compare to identify changes from the flatfile source to the database table so that we can insert, update and delete records.
Add a table comparison
Join the table compare
Complete the necessary parameters
Learn how to identify unique records in the table
This demo is filmed in the SAP Data Services 4.2 environment, but it is applicable to 4.x and 3.x (SAP Data Services 4.1, 4.0)
Discover more tutorial videos at www.wciconsulting.com