DSXchange

rleishman wrote: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.

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

viewtopic.php?p=266777

rleishman wrote: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.

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.