I have a requirement, here I need to compare target with source by using 2 columns 1 is primary key & other is hash key.
If the same record is present in target table with change in some columns, instead of updating that record i want to change the flag with end_date & store it in the same table.
@ShaX,You can do with tMap and there inner join on 2 columns ,source would be main and target would be lookup and then take the inner join rejects into output and then there you create a new field end_date and set current date for end_date and insert into target.
@ShaX,You can do with tMap and there inner join on 2 columns ,source would be main and target would be lookup and then take the inner join rejects into output and then there you create a new field end_date and set current date for end_date and insert into target.
