Hi,
In my job one of the column name data type is Decimal(15,7). When I view the data in DB data comes in proper format like below
COLUMN NAME
----------------
2003.0000000
But when try to view the same column (data type is Decimal(15,7) ) in datastage data comes in below mentioned format.
COLUMN NAME
----------------
20030000000
Can you help me why I am getting data in this format in datastage.?
Do I need to change any data type in DS?
Decimal Issue
Moderators: chulett, rschirm, roy
Decimal Issue
prabakaran.v
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
What datatype you have defined in datastage metadata and what is database?
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/