NextSurrogateKey()

[goutam]

Are you trying to use NextSurrogateKey() in a Stage Variable?

If so, I don't believe that you can. You can only use it in an output link column derivation.

Hi all

I read all the post for this topic. I was also tring to generate surrogate key thru surrogate key generator stage . I also got the same error message as srimtta was getting. I am wondering , does this key source name (State file name along with path) should be present in windows drive and not the UNIX?. My IS 8.0.1 is installed on UNIX.


srimitta , have you succeded at last or still pending?
if succeded ..then please help me out.

[chulett]

If you feel like helping, do so over in the other thread that goutam (properly) opened for this:

viewtopic.php?p=266777

[I_Server_Whale]

Are you trying to use NextSurrogateKey() in a Stage Variable?

If so, I don't believe that you can. You can only use it in an output link column derivation.

You can get a patch from IBM to call it in a stage variable.

[ds_is_fun]

Seems like you did not create the source key first using DS.
Read the reply-viewtopic.php?p=266794&highlight=#266794 that I just wrote.

Also remember that there is a different way to initialize it. You will need to create the source file and manually create a initialization flat file.
In the transformer stage point to the initialization file through a job parameter and point to the location of the source file.