SAP Business Objects Data Services - Table Comparison Transform

Table comparison transformation is used to compare the two data sets and   check what are the records were changed and updates, inserted and deleted.

Comparing two data sets, this transform can generate the difference between them as a resultant data set with each row of the result flagged as insert, update, or delete.

-          Create the design.

-          Open the query and do mapping.

-          Open Table Comparison and do following changes.

·         Give filter conditions relevantly.

-          Execute the job.

-          Compare results.