table structure differ from actual table in oracle

balu124 · Post by **balu124** » 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?

Maveric · Post by **Maveric** » Mon Oct 29, 2007 12:02 am

Did you try running the job by changing the data types to integer and date respectively?

vmcburney · Post by **vmcburney** » Mon Oct 29, 2007 12:11 am

You could try importing the table definition using the Import "Orchestrate Schema Definition" instead of the Plug-in importer. It might give you more accurate metadata for a parallel job. It's a bit trickier to use but it can log into Oracle to get metadata and creates a normal table definition that you can use in a job.

balu124 · Post by **balu124** » Mon Oct 29, 2007 1:04 am

Maveric wrote:Did you try running the job by changing the data types to integer and date respectively?

Hi Maveric,
when we change the target metadata and run the job we got the errors like this numaric value ou of range

balu124 · Post by **balu124** » Mon Oct 29, 2007 1:10 am

Maveric wrote:Did you try running the job by changing the data types to integer and date respectively?

Hi Maveric,
when we change the target metadata and run the job we got the errors like this numaric value ou of range even we define the metadata correctly

balu124 · Post by **balu124** » Mon Oct 29, 2007 1:15 am

vmcburney wrote:You could try importing the table definition using the Import "Orchestrate Schema Definition" instead of the Plug-in importer. It might give you more accurate metadata for a parallel job. It's a bit ...

Hi vmcburney,
Could you please explain me the steps in importing the oracle tables using "Orchestrate Schema Definition" .

I imported using odbc table definitions.

and also please let me know dsn is separetly defined for this as I defined the older dsn using odbc drivers.