• Option - 1: You can make use of LookUp and Condition Split Transformation to achive this.

    Option - 2: You can do this by Creating a Procedure.

    A. Load all the data's to Staging Table.

    B. Create Procedure and load latest data's, by Comparing Staging and Fact table data's and then load the latest data's.