Now do left join (file with table)-so we get all records from left table matched records from right table and nulls from right table whihc are not matched
take required columns
use conditional split
expire the records then insert all the records which are available from file as active=1
SCD Type-2 in Dataflow
first read the files and table
Now do left join (file with table)-so we get all records from left table matched records from right table and nulls from right table whihc are not matched
take required columns
use conditional split
expire the records then insert all the records which are available from file as active=1