load data into Oracle table

[sheema]

Hi,

I have a simple job design which reads from a oracle table Tbl1(using Oracle Enterprise stage) and loads (appends data) into another oracle table Tbl2.


From first table we are extracting below columns in the following order

Col1 Varchar
Col2 Varchar
Col3 Varchar
Col4 Date
Col5 Date
Col6 Decimal
Col7 Decimal

In the transformer we add 3 more columns to the above columns and try to load into Tbl2.In the Tbl2 the columns are in the below order
(so the in the transformer too are in the below order)

Col1 Varchar
Col2 Varchar
NewCol1 Varchar
NewCol2 Varchar
Col3 Varchar
Col4 Date
Col5 Date
Col6 Decimal
Col7 Decimal
NewCol3 Date

The column names and datatypes in the database match with the above mentioned columns. Runtime column propogation is also not selected.

when i try to run the job i get the below fatal error

Describe failed because of a missing column for Col6.

In the Target Oracle Enterprise stage I have Write Method as Load and Append as the Write Mode.

Can anyone help me come across this error.

Thanks

[abc123]

You need to set the environment variable $APT_DISABLE_COMBINATION to True in your job parameters and re-run the job. This will tell you exactly which stage is causing the error.

[ray.wurlod]

Adding columns to the Transformer stage will prove fruitless unless those new columns also exist in the Oracle table.
The error message suggests that your Oracle table still has only seven columns.