Monday, February 16, 2015

Assigning a Batch Number Using Sequence Generator

Assigning a Batch Number Using Sequence Generator

In my case  i have scenario ..

batch_num column assign a values group of 1000 

In case  i used a sq transformation  and mod function in Informatica  expression transformation.




Or We can do it from different ways....:)




No comments:

Post a Comment

ADF functions

 toString(JT_DEAL_PLAN_EFF_DT, 'MM/dd/yyyy HH:mm:ss','es-ES')