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