Surrogate Key Generation Issue

pavankvk · Post by **pavankvk** » Fri May 18, 2012 2:42 pm

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?

pandeesh · Post by **pandeesh** » Fri May 18, 2012 10:17 pm

Have you looked into the source for your surrogate key values?Probably a state file..

pavankvk · Post by **pavankvk** » Sat May 19, 2012 6:49 am

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

pandeesh · Post by **pandeesh** » Sat May 19, 2012 6:54 am

Make sure you are running in sequential mode and re initialize your state file and start from the beginning .

ankursaxena.2003 · Post by **ankursaxena.2003** » Sat May 19, 2012 7:07 am

Do you have a Server job or Parallel job?
Did you try using Surrogate Key Generator?

ankursaxena.2003 · Post by **ankursaxena.2003** » Sat May 19, 2012 7:10 am

Do you have a Server job or Parallel job?
If you are using Parallel Job. Then did you try using Surrogate Key Generator?

pavankvk · Post by **pavankvk** » Sat May 19, 2012 7:55 am

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.

pavankvk · Post by **pavankvk** » Sat May 19, 2012 8:03 am

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

pavankvk · Post by **pavankvk** » Sat May 19, 2012 8:09 am

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.

ankursaxena.2003 · Post by **ankursaxena.2003** » Sat May 19, 2012 9:02 am

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.

pavankvk · Post by **pavankvk** » Mon May 21, 2012 8:52 am

Any ideas?

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2012 5:06 pm

pavankvk wrote:Any ideas?

See above.

pavankvk · Post by **pavankvk** » Mon May 21, 2012 5:15 pm

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