Hi,
I am implementing a surrogate key stage in my job, but the stage is not giving proper sequence and i have given below properties
block size - 1
next highest value - yes
but still giving un sequence number the result is coming like
EMPNO,ENAME,SKEY
1,JA,45
2,GA,64
3,KL,92
4,JK,94 Please can any one help in this case
Getting non-proper sequence result by surrogate stage
Moderators: chulett, rschirm, roy
Re: Getting non-proper sequence result by surrogate stage
Are you running your job with multiple node setting? Could you try running with single node setting and see?
Thanks,
Sudhakar
Sudhakar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Re: Getting non-proper sequence result by surrogate stage
Is this sample data or real data that you are using? Can i assume that you have only 4 records in input?deesh wrote: EMPNO,ENAME,SKEY
1,JA,45
2,GA,64
3,KL,92
4,JK,94
Or if you are just showing us 4 records as a sample, then sort the output by SKEY and check whether SKEY is generated in order.
E.g. if you have 100 records in input, first record may have SKEY as 10 and 20th record may have SKEY as 1. It all depends on your partition.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!