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?
table structure differ from actual table in oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Hi vmcburney,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 ...
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.