1 Reply Latest reply on Dec 27, 2019 12:52 AM by Pierre Martignon

    Recursive solution to find ultimate parent for a child

    Tavneet Singh New Member

      Hi,

       

      I have a scenario, where we need to find the ultimate parent of a child using Informatica DEI (BDM) tool. There is no  Below is the example:

       

      Source Data:

      Customer_key
      Target_Customer_Key
      12
      23
      34
      46
      56
      67
      910

       

      Target Data:

      Customer_key
      Target_Customer_Key
      17
      27
      37
      47
      57
      67
      910