DSXchange

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?

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

Thanks for your reply.

In datastage metadata I have defined for that source column Decimal

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