Table comparison Issue

[Former Member]

Hi all,

   Created job using table comparison transform. I compared source with target on record_id field .Rows that doesn't matched on record_id should insert in target table,this is my requirement. But in target all data from source getting inserted into target. can you suggest me how solve this issue.

Table comparison options:

[Former Member]

Specify generated key column. Then give the Input primary key columns and list all the columns in 'Compare Column' you want to compare against.