DSXchange

You can accomplish this into one job. All you need is a lookup to you database table and you can find out what is the max(Key) then you can start your surrogate_key_generator stage with a starting value of 1. Use a stage variable to add the Key value which is generated by surrogate key and the max v...

What you can do is go to Director and select the job which is in question. and then select "Job" menu select the option "Cleanup resources" , you may get an error messege that no process were found for the job. ignore that and press ok. You will get a new popu window you will see...

I am trying to generate the surrogate key for a type one dimension. and it is an ongoing load stratergy. I am using usrrogate key generator stage. But I need to set the start value of the surrogate key so that it should start from the max(exixintg values) and start from there. They way I am trying t...

hello I am having a problem in getting right result from a basic routine I wrote. When I test it from the Test button it runs fine and give the desired results. But when I try to debug the job and watch the output of the Routine , it gives the invalid results. I am not sure is there anyway I can but...