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
Watch video How to Use the Table Compare Transform in SAP Data Services online without registration, duration hours minute second in high quality. This video was added by user WCI Data Solutions 25 June 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 25,366 once and liked it 88 people.