3 Replies Latest reply on May 23, 2019 5:28 AM by Nico Heinze

    Informatica - load latest record and maintain history

    v kase Active Member

      Hello,

       

      I have records coming like this from source. where for all incoming record status would be A and status_D would be sysdate.

       

       

       

       

      StatusIDFlagStatus_D
      A123456789Ysysdate
      A34517896Ysysdate

       

       

      in the target I have to check whether that ID exisits, if yes then make it as Inactive (Status=I) and insert new record as A.

      if record is not there in target then insert it as A.

       

      Could you please guide me how to achieve this and along with ID which column should be key columns.

       

      StatusIDFlagStatus_D
      I123456789Y1/1/2018
      I123456789N9/1/2018
      I123456789Y12/1/2018
      A123456789N1/1/2019
      A34517896Y1/1/2018