6 Replies Latest reply on May 25, 2020 5:10 AM by Dharmendra Reddy Nara

    Consolidation Transformation in Informatica 9.1.0

    Joydip Ghosh Active Member

      Hi all,

       

      I am trying to consolidate a record in Informatica 9.1.0 Developer tool. Here we faced a situation that we need to consolidate our record based on a given feild which is the Most Recent Update Date Feild. Now if this mose recent update feild contains a null, the value should be checked with other records if we found a value in that column, the final record will fill the value from there, an example is as follows

       

      Suppose

       

       

      Association IDNamePhoneNumberSSN_NumberLast_Update_DAte
      1Tammy12345112426-10-2010
      1Tam

      12346


      25-10-2011
      1Tammy
      1124525-10-2012
      1Tam1234561124611-11-2011

       

      Then the result will be

       

      Association IDNamePhoneNumberSSN_NumberLast_Update_DAte
      1Tammy1234561124525-10-2012

       

       

      how to achive this in consolidation. Please help with the scenario, we havent find any function here in consolidation based on this case..

       

      Thanks and Regards

      Joydip Ghosh.