Hi All
I have job in Production which will compare the previous day and current day files in CDC stage then generating sequence numbers in transfer stage (running in sequence mode ) for every new record.
Transformer logic. if lnklkptotfp.change_code =1 then @NUMPARTITIONS+svCntr else svCntr
Now the job is generating negative numbers
Can you please suggest what could be the issue
Thanks,
Sequence numbers are generating in native
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 47
- Joined: Tue Sep 13, 2005 4:28 am
Sequence numbers are generating in native
Kiran Kumar
-
- Premium Member
- Posts: 47
- Joined: Tue Sep 13, 2005 4:28 am
What is the datatype and intial value for the stage variable svCntr.
Could be a reason that, garbale value is going due to data type mismatch?
Did you check the Target table? No chance of getting negative value as the Max?
Is the Negative value going incremental or reverse?
Could be a reason that, garbale value is going due to data type mismatch?
Did you check the Target table? No chance of getting negative value as the Max?
Is the Negative value going incremental or reverse?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Premium Member
- Posts: 47
- Joined: Tue Sep 13, 2005 4:28 am