This video provides a hands on demo on how to read sql source table, generate hash key, compare source records with target records and inserts new records into target table.
This shows how to use derived column, exists , sink component in data flow .