Generating Sequence number for primary key at Taget oracle T
Posted: Fri May 13, 2011 12:01 am
Hi
OracleEntstage---->Transformerstage----->OracleEntstag
I am using select query in OracleEnt stage.Selecting six columns.
I am using Transformer stage. In Tx stage, adding a new column(int (10)) Run_ID on output link of Transformer.
New column (in TX stage) is a primary key in the Target table.
I am using Oracle Ent stage to insert all seven columns into a target table.with options below
updsert mode = user defined update and insert
upsert order = insert then update
write method = upsert
For Run_ID column value is { VALUES (schema.SEQ_AUDIT_RUN.nextval,ORCHESTRATE.column2,ORCHESTRATE.column3......
Job is aborting and error is below
main_program: Field Run_ID is not in the input data set.
main_program: Creation of a step finished with status = FAILED.
Can any one advise me in this issue.
Thanks
Srini
OracleEntstage---->Transformerstage----->OracleEntstag
I am using select query in OracleEnt stage.Selecting six columns.
I am using Transformer stage. In Tx stage, adding a new column(int (10)) Run_ID on output link of Transformer.
New column (in TX stage) is a primary key in the Target table.
I am using Oracle Ent stage to insert all seven columns into a target table.with options below
updsert mode = user defined update and insert
upsert order = insert then update
write method = upsert
For Run_ID column value is { VALUES (schema.SEQ_AUDIT_RUN.nextval,ORCHESTRATE.column2,ORCHESTRATE.column3......
Job is aborting and error is below
main_program: Field Run_ID is not in the input data set.
main_program: Creation of a step finished with status = FAILED.
Can any one advise me in this issue.
Thanks
Srini