Hi all,
I have a problem in importing oracle table definiton. In oracle table one field is of datatype NUMBER(10), but when I import that into Datastage it is taking as BigInt. Beacuse of this data stage is taking wrong data. For example Im having value '-2525814614' in oracle table for this field but datastage is importing it as '-2147483648'. Pls help me out in handling this.
Thank u.
Problem with importing table definition
Moderators: chulett, rschirm, roy
Problem with importing table definition
Thanks,
Raamc
Raamc
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try importing it using the Orchestrate orchdbutil facility. This is known to be more accurate than other importers.
Import > Table Definitions > Orchestrate...
Import > Table Definitions > Orchestrate...
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:
Then the only remedy is to edit the table definition after you've imported it. Add a comment in the Description field to alert other developers that you've had to do this, and why.
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.