We have to develop one mapping for a field as - "Initialise to 3000. Increase by 1 for every 5000 records."
Please suggest how to develop this. Thanks.
Increment 1 Digit After Certain Number of Records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Integer stage variable svExample initialised to 3000.
Derive stage variable svExample as
Execute Transformer stage in sequential mode.
Derive stage variable svExample as
Code: Select all
svExample + Not(Mod(@INROWNUM,5000))
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.