Surrogate generation from sequence.
Posted: 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.
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
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.
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