Hello,
What i am trying to do is -->
1> There is a set of input of 1000 customers.
2> I have to generate serial number - 1- 1000 against all these customers.Hence i used Column Generator stage. I define Count - Bigint and set Start numbering from 1,Increment by 1.
3>Now when i run the job first time i get a count from 1 -1000.
4> This works fine and i get the desired output.
My requirement is -->
1> when i will run the job second time the count should not start from 1001 -onwards and end on 2000 .I am not able to get this work.Similarly when i run the job 3rd time count has to begin with 2001.
I have something in mind like using tranformer and storing the last count.I tried but this was getting difficult.
Second is parameterizing.But no ideas how to parameterise? How to store last count etc?
Please share with me if anyone has suggestions to help out this scenario.
How to recount when the job runs again
Moderators: chulett, rschirm, roy
Another approach is to use a database sequence directly, or use the new V8 sequence functionality in Transform stages
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is also a Surrogate Key Generator, which is what I believe nagarjuna meant. But a Column Generator would do as well; either way you will need to initialize the sequence. And beware of parallel processing.
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.