/ / Load last record in a Table with Informatica
Scenarios

Load last record in a Table with Informatica

Edit

  • Create source and target with same structure and drag them in to the mapping designer. 
  • Create an expression transformation and connect source ports to expression.
  •  Add two new ports one is variable port other is output port. write expression like below
                                       V_Count=V_Count+1
                                       O_Count=V_Count  

  • Create sorter transformation connect all ports from expression to sorter. 
  • Edit Sorter->select O_Count as key column->Make it descneding order. 

  • Create other expression transformation and connect all ports from expression to sorter except output port.
  • Add  again two new ports.
                                       V_Count=V_Count+1
                                       O_Count=V_Count  

  • Create filter transformation connect all ports from expression to filter 
  • Add condition to filter O_Count=1 
  • Connect filter to target table. 
  • The output will be like below



Powered by Blogger.