Regarding pivot stage
Posted: Thu Jan 18, 2007 8:12 pm
Hi,
I created a table in oracle database using following query
create table salma(customerid number, ename varchar2(20),jansales decimal(12,2),febsales decimal(10,2))
My design is odbc---->pivot---->odbc.
Iam calling this table in my source odbc stage.
when i run the job ,iam getting peculiar error.
ob2..ODBC_0.DSLink3: DSD.BCIOpenR results of SQLColAttributes(CUSTID) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Decimal.
when seeing this error.i tried to change the datatype in my created table in oracle to decimal but its not accepting.
I really feel embrassed to post this error, but please help me to analyze the error.
cheers;
vijay
I created a table in oracle database using following query
create table salma(customerid number, ename varchar2(20),jansales decimal(12,2),febsales decimal(10,2))
My design is odbc---->pivot---->odbc.
Iam calling this table in my source odbc stage.
when i run the job ,iam getting peculiar error.
ob2..ODBC_0.DSLink3: DSD.BCIOpenR results of SQLColAttributes(CUSTID) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Decimal.
when seeing this error.i tried to change the datatype in my created table in oracle to decimal but its not accepting.
I really feel embrassed to post this error, but please help me to analyze the error.
cheers;
vijay