Surrogate Key stage in Datastage 8.0

rob47329 · Post by **rob47329** » Fri Jan 23, 2009 3:47 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Jan 23, 2009 4:08 pm

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.

rob47329 · Post by **rob47329** » Fri Jan 23, 2009 4:41 pm

Sounds like 8.x will still require a routine to get the result of query to the surrogate stage.

thx

ray.wurlod · Post by **ray.wurlod** » Fri Jan 23, 2009 8:40 pm

No, you can do it with a job. A server job is probably the more efficient since only one row is to be processed.