Page 1 of 1
Surrogate Key Generation Issue
Posted: Fri May 18, 2012 2:42 pm
by pavankvk
Hi,
We are using a transformer stage operating in sequential mode to generate the surrogate key. Using next surrogate key function. The values generated have different ranges
like
1,
300000,
2,
3000001
and so on..what could be the issue?
Posted: Fri May 18, 2012 10:17 pm
by pandeesh
Have you looked into the source for your surrogate key values?Probably a state file..
Posted: Sat May 19, 2012 6:49 am
by pavankvk
pandeesh wrote:Have you looked into the source for your surrogate key values?Probably a state file..
I don't see anything wrong with the state file
Posted: Sat May 19, 2012 6:54 am
by pandeesh
Make sure you are running in sequential mode and re initialize your state file and start from the beginning .
Posted: Sat May 19, 2012 7:07 am
by ankursaxena.2003
Do you have a Server job or Parallel job?
Did you try using Surrogate Key Generator?
Posted: Sat May 19, 2012 7:10 am
by ankursaxena.2003
Do you have a Server job or Parallel job?
If you are using Parallel Job. Then did you try using Surrogate Key Generator?
Posted: Sat May 19, 2012 7:55 am
by pavankvk
pandeesh wrote:Make sure you are running in sequential mode and re initialize your state file and start from the beginning .
Yes, i am running on sequential mode and initialized the state file. I can't use surrogatekey generator at this point.
Posted: Sat May 19, 2012 8:03 am
by pavankvk
ankursaxena.2003 wrote:Do you have a Server job or Parallel job?
If you are using Parallel Job. Then did you try using Surrogate Key Generator?
Its a parallel job,but the transformer is operating in sequential mode. Also the config file has only 1 node. so it doesnt really matter
Posted: Sat May 19, 2012 8:09 am
by pavankvk
The state file looks something like this
1 554
300000 3000001
Until the value hits 555, i see this behavior of inconistent ranges.once it his 555, the behavior is no longer seen and generates normally.
Posted: Sat May 19, 2012 9:02 am
by ankursaxena.2003
Why don't you try using Surrogate Key Generator.
Check out the link below:
http://dsxchange.com/viewtopic.php?t=14 ... ffeda35239
I am also facing some problem with Surrogate Key Generator. But, it will give you consecutive number to certain extent. I have opened a PMR with IBM. And you don't need to run it in Server mode.
Posted: Mon May 21, 2012 8:52 am
by pavankvk
Any ideas?
Posted: Mon May 21, 2012 5:06 pm
by ray.wurlod
pavankvk wrote:Any ideas?
See above.
Posted: Mon May 21, 2012 5:15 pm
by pavankvk
I would not have asked, if those worked. as a matter of fact, i would not have posted here with out exploring all the scenarios at my end