Generating Sequence number for primary key at Taget oracle T

[srinivas Guduru]

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

[ray.wurlod]

Don't include the RUN_ID column in your design. Mention it only in the user-defined SQL.

I presume you are using an Oracle sequence because there are likely to be other processes inserting rows into this table at the same time that you are. Otherwise consider using a surrogate key stage, which you can initialize from the target table itself.