Surrogate generation from sequence.

chetan.c · Post by **chetan.c** » Thu Mar 15, 2012 2:54 am

Hi,

I'm trying to understand the Surrogate key generator stage.
Below is my job design to test the Surrogate jey generator stage with Oracle Sequence.

Code: Select all

 Surrogate_key_gen----->Flat_File/Peek.

What i'm trying to do is to configure the Surrogate key stage to generate the key from Oracle sequence and view the output data.

First Question: Is the job design correct to understand the Stage configuration using oracle sequence.
If yes then below is the configuration properties i have set.
Database type:Oracle
Oracle_server_name:Name of the server
Password:Password for the connection.
User Name:User name for the connection.

Generated output column name:PK.
Source name:SEQ.TEST
Source Type:Database sequence.

Under options::
Number of Records:10.

There is only one output column which is the SurrogateKeyGen(PK).

When im running the job it aborts with Expected "," or "}" got "User name value" with one character less.
Example if User name is DBUser then BUser.

What am I not doing correctly in this job.?

Thanks