Scenarios

Reverse the records of file in informatica


  • Create source and target table with the same structure.
  • Drag both source and target in to the mapping designer.
  • Create an expression transformation and connect all ports from source qualifier to expression.
  • Add two ports in expression transformation, one is variable and the other output port.
  • Variable port: V_Count:V_Count+1
  • Output Port: O_Count=V_Count  
  • Create sorter transformation and connect all ports from expression to sorter.
  • In the sorter make sort key as O_Count and sort order is Descending
  • Connect ports from sorter to target table. 
Powered by Blogger.