/ / Sending alternate record to target in Informatica
Scenarios

Sending alternate record to target in Informatica

Edit

  • Drag the Source and Target to the mapping designer.
  • Connect Source to an expression transformation.
  • Add the next value of a sequence generator to expression transformation. 
  • In expression transformation make two port, one is "odd" and another "even". And Write the expression like below. 
  • odd=iif(NEXTVAL%2=0,1,0)
  • even=iif(NEXTVAL%2=1,1,0) 
  • Connect a expression transformation to router.
  • Make two groups in router. And give condition  Like below 
  • In odd group odd=1 
  • In even group odd=0
  • Connect router transformation two groups to two target tables.




Powered by Blogger.