5 Replies Latest reply: Dec 17, 2015 11:19 PM by yashdeep chauhan RSS

    Check whether there is any modification in data in Incremental Load

    yashdeep chauhan

      Hi All,

       

      I am getting one .txt file every day which I have to Concatenate to the existing qvd File.

      The file coming every day may have old records.

      I am using incremental load for This and using "not exists()" to avoid duplicate values.

      There is no Modified date field in The table.

      but

      this will simply load the new data and not old one.

      What I want is if there is any change in Field "Leaving Date" of Same Emp ID It should capture it.

       

      Primary Key = Emp ID.

      Field to check for modification = "Leaving Date".

       

      Thanks in advance.