Metadata import from Oracle 11g to Datastage
Moderators: chulett, rschirm, roy
Metadata import from Oracle 11g to Datastage
Hi
I am trying to import metadata from ORACLE 11g to Datastage via Connector import Wizard .
In oracle column defined as NUMBER (10) that means it equal to Datastage Integer. But when I import it is showing Decimal 10 instead of Integer.
NUMBER(10) .
Is this anything I have to change in setting ?
Thanks
Man
I am trying to import metadata from ORACLE 11g to Datastage via Connector import Wizard .
In oracle column defined as NUMBER (10) that means it equal to Datastage Integer. But when I import it is showing Decimal 10 instead of Integer.
NUMBER(10) .
Is this anything I have to change in setting ?
Thanks
Man
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ANSI standard SQL does not have a data type called NUMBER. Indeed, as far as I am aware, nor does any database apart from Oracle.
Oracle is... different.
In DataStage, the data types DECIMAL and NUMERIC are considered to be the same. There are only a couple of databases in which the nuances make these different; DataStage stores them in the same way. You can learn about DataStage data types in Chapter 2 of Parallel Job Developer's Guide.
Oracle is... different.
In DataStage, the data types DECIMAL and NUMERIC are considered to be the same. There are only a couple of databases in which the nuances make these different; DataStage stores them in the same way. You can learn about DataStage data types in Chapter 2 of Parallel Job Developer's Guide.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not something I've done recently, but it certainly appears that way.
There's nothing to prevent you from adjusting the imported metadata, but you risk getting metadata mismatch warnings if you do.
There's nothing to prevent you from adjusting the imported metadata, but you risk getting metadata mismatch warnings if you do.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.