warning

sundar · Post by **sundar** » Tue Sep 25, 2007 7:55 am

Hi all,

My source database is oracle and the column key_1 datatype is number(10), I am able to view the records in the source.

In Datastage it is decimal 38,10

when i run the job,i am getting the following warning
SrcTltr: Column KEY_1 floating point decimal is not fully supported; adjusting the scale.

Regards
Sundar

abhi989 · Post by **abhi989** » Tue Sep 25, 2007 1:56 pm

You have number(10) defined in your source column, and you decimalhave defined 38,10 defined in DS. Change Decimal 38,10 just to 38 (remove the scale value) should fix the problem

ray.wurlod · Post by **ray.wurlod** » Tue Sep 25, 2007 4:45 pm

How did it get to be DECIMAL(38,10) in DataStage, if it's NUMBER(10) in the database? Did the database change after the table definition had been imported?

Perhaps your site has some metadata management issues that need to be addressed.

arun@sinmax · Post by **arun@sinmax** » Wed Sep 26, 2007 1:13 am

Hi

How you import the table definition.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 26, 2007 1:27 am

Import through plug-in is known to be inaccurate for OCI. Import using Orchestrate orchdbutil facility.