DECIMAL TO DECIMAL CONVERSION REDUCTION IN SIZE
Moderators: chulett, rschirm, roy
DECIMAL TO DECIMAL CONVERSION REDUCTION IN SIZE
My incoming datatype is Decimal (38,10) which has to be mapped to Decimal (18,0) field. The incoming data will never have decimals. How do I got about reducing the size. The target database is teradata.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try performing simple arithmetic (adding zero is good) in a Transformer stage. DataStage should look after the metadata transition across the Transformer stage.
Beware, however, that any source number with more than eighteen significant digits will fail to load into the target.
Beware, however, that any source number with more than eighteen significant digits will fail to load into the target.
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: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Open the row (Edit Row in the Columns grid) and set the Decimal Type sub-property. Click on Help to learn more about what this does. Beware that the data browser (View Data) may add leading zeroes to the display of decimal fields whether or not they are actually there in the data.
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.