Page 1 of 1

Surrogate Key stage in Datastage 8.0

Posted: Fri Jan 23, 2009 3:47 pm
by rob47329
Hello all,

I currently work with DS 7.5.2 and am wondering if the surrogate key stage in DS 8.x accepts a table name as an option.

In 7.5.2 it only accepts a 'starting value'.

Thanks

Posted: Fri Jan 23, 2009 4:08 pm
by ray.wurlod
Welcome aboard. The short answer is that it does not. You create a job to initialize the next key value by effecting a SELECT against the table.

Posted: Fri Jan 23, 2009 4:41 pm
by rob47329
Sounds like 8.x will still require a routine to get the result of query to the surrogate stage.

thx

Posted: Fri Jan 23, 2009 8:40 pm
by ray.wurlod
No, you can do it with a job. A server job is probably the more efficient since only one row is to be processed.