Decimal Issue

[praburaj]

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?

[prasson_ibm]

What datatype you have defined in datastage metadata and what is database?

[praburaj]

Thanks for your reply.

In datastage metadata I have defined for that source column Decimal

(15,7) and my database is SQL server.