table structure differ from actual table in oracle
Posted: Sun Oct 28, 2007 11:20 pm
Hi ,
In oracle the data type for a column in a table is integer.I imported the table in to datastage repository by assisted approach .
When I tried to define the columns for that table in source stage ,the data type of integer column appearing as decimal.and same case with date (original) and timestamp(converted in datastage).
when we execute the job keeping the same(not converting) the job gets aborted and we got the following error
implicit conversion not possible from timestamp to date,implicit conversion is not possible integer to decimal.
how to solve this?
In oracle the data type for a column in a table is integer.I imported the table in to datastage repository by assisted approach .
When I tried to define the columns for that table in source stage ,the data type of integer column appearing as decimal.and same case with date (original) and timestamp(converted in datastage).
when we execute the job keeping the same(not converting) the job gets aborted and we got the following error
implicit conversion not possible from timestamp to date,implicit conversion is not possible integer to decimal.
how to solve this?