Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
pavankvk
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
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..
pandeeswaran
pavankvk
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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
Premium Member
Posts: 1399 Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU
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 .
pandeeswaran
ankursaxena.2003
Participant
Posts: 96 Joined: Mon May 14, 2012 1:30 pm
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
Participant
Posts: 96 Joined: Mon May 14, 2012 1:30 pm
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
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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.
pavankvk
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
Post
by pavankvk » Mon May 21, 2012 8:52 am
Any ideas?
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon May 21, 2012 5:06 pm
pavankvk wrote: Any ideas?
See above.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pavankvk
Participant
Posts: 202 Joined: Thu Dec 04, 2003 7:54 am
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