handel DBSequence with surrogate Key in transformer

yollsonlegrand · Post by **yollsonlegrand** » Fri Nov 28, 2008 8:22 am

Hello,

I want to populate a table with help for Surrogate Key in aTransformer. I'm not comming right to deal with the DBSequence I'v allready configured in the tab surrogate Key of the Transformer.How to call This in the corresponding Fiedl the Table and insert the value in the corresponding FIELD for each row? My configuration:
Data_set File --->Transformer ---->Table
Thanks in advance for your Help.

ArndW · Post by **ArndW** » Fri Nov 28, 2008 9:05 am

You need to derive this using the "NextSurrogateKey" function.

yollsonlegrand · Post by **yollsonlegrand** » Fri Nov 28, 2008 2:59 pm

ArndW wrote:You need to derive this using the "NextSurrogateKey" function. ...

Do you mean after seeting the DBsequence in the Transformer stage I' ve to set the FIELD(CLIENT_TK) with the Derivation "NextSurrogateKey" in Double Quote?
Other like this NextSurrogateKey()?
I set like you say with double Quote.. According to the job runing, It was 22 Rows insert int the tabe without warning. But when I look into the table, I only see one row with a Keynumber 0. The KeyNumber is the value of the NextSurrogateKey value for the one Rows that is to see instead of the 22 Rows.
I don't understand Why.
Has any one an idea? Please tell me what I'm doing wrong.

ArndW · Post by **ArndW** » Sat Nov 29, 2008 5:35 am

Please read the documentation on "NextSurrogateKey" - it is not a constant, but a function that you can select from the function list in Transform stage derivations. Parallel Job Developers Guide, Chapter 11, page 183.