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.
handel DBSequence with surrogate Key in transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 51
- Joined: Fri Nov 07, 2008 8:03 pm
handel DBSequence with surrogate Key in transformer
Yollson Empereur
-
- Participant
- Posts: 51
- Joined: Fri Nov 07, 2008 8:03 pm
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?ArndW wrote:You need to derive this using the "NextSurrogateKey" function. ...
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.
Yollson Empereur