Hi all,
How to generate a unique sequence number in DataStage using transformer stage?
I donot want the sequence number to be duplicated and the last record should give the count of number of records, for eg., if i pass 100 records, i should get all the values from 1 till 100 without any holes.
Thanks in advance!
how to generate a unique sequence number in DataStage
Moderators: chulett, rschirm, roy
Create Round Robin partition and use the logic that you are using (as specified in your other post). Again it will minimize the so called hole, but not all.
If you are more concern about sequence number, run the job in Sequential mode, atleast the Transformer and use simply @INROWNUM.
If you are more concern about sequence number, run the job in Sequential mode, atleast the Transformer and use simply @INROWNUM.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
thanks Kumar, it worked!!!kumar_s wrote:Create Round Robin partition and use the logic that you are using (as specified in your other post). Again it will minimize the so called hole, but not all.
If you are more concern about sequence number, run the job in Sequential mode, atleast the Transformer and use simply @INROWNUM.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: