Oracle enterprise stage
Posted: Thu Oct 09, 2008 8:49 am
I have the below user defined sql in Oracle Enterprise stage(which reads data from a table)
Select
Col1,
Col2,
col3,
decode(Col4,null,'A','B')
from Table1
But I am getting the below warning when i try to view the data.
I am getting the warning Input dataset could not find column Col4.
In the columns tab of Oracle Enterprise stage I have loaded the metadata from the table instead of typing,the name of column against col4 is Col4 in the columns tab.
If i remove the decode function then I am able to view the data.
The sql statement with the decode function works perfectly at the oracle sql prompt.
Any idea what is causing this error.
Thanks
Select
Col1,
Col2,
col3,
decode(Col4,null,'A','B')
from Table1
But I am getting the below warning when i try to view the data.
I am getting the warning Input dataset could not find column Col4.
In the columns tab of Oracle Enterprise stage I have loaded the metadata from the table instead of typing,the name of column against col4 is Col4 in the columns tab.
If i remove the decode function then I am able to view the data.
The sql statement with the decode function works perfectly at the oracle sql prompt.
Any idea what is causing this error.
Thanks