Dataset with a different structure
Posted: Fri Aug 18, 2006 9:03 am
Hello,
I have a job which is used to concat several Datasets into one to be loaded into an Oracle table.
So, its design is
Each input Dataset have the structure:
Col1
Col2 (used for the lookup reference)
Col3
Col4
And my Output Dataset is
Col1
Col3
Col4
Col5 (from the Oracle table)
I don't have the RCP activated but my Dataset is created as:
Col1
Col2
Col3
Col4
Col5
As my Load job is a generic one for which I need to have the same structure for the Dataset and the table, I keep having the same error:
ORA_BD: Describe failed because of missing column for Col2
I already tried everything (I think ):
- Copy the job
- Delete the link and the Dataset and recreate it
- Create it with another name...
I also tried to put the option "Silently Drop Columns Not In Table" = True, but this generates warnings.
What can I do to solve this problem?
tkx
I have a job which is used to concat several Datasets into one to be loaded into an Oracle table.
So, its design is
Code: Select all
Oracle
Dataset_1 |
.. --> Funnel --> Lookup --> Dataset
Dataset_n
Col1
Col2 (used for the lookup reference)
Col3
Col4
And my Output Dataset is
Col1
Col3
Col4
Col5 (from the Oracle table)
I don't have the RCP activated but my Dataset is created as:
Col1
Col2
Col3
Col4
Col5
As my Load job is a generic one for which I need to have the same structure for the Dataset and the table, I keep having the same error:
ORA_BD: Describe failed because of missing column for Col2
I already tried everything (I think ):
- Copy the job
- Delete the link and the Dataset and recreate it
- Create it with another name...
I also tried to put the option "Silently Drop Columns Not In Table" = True, but this generates warnings.
What can I do to solve this problem?
tkx