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
load data into Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The error message suggests that your Oracle table still has only seven columns.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.