Data validation issue in DS 9.1 environment

[ysrini9]

In this specific issue In the Source Table, the Column name -> Source has been defined as Char in both DataStage 7.5 & 9.1 environment.
On detailed analysis of the view data, the following data get populated in the 7.5 environment
Target Column _> DCMNT_TYPE_CD is getting populated with the following values : 00400001 and 00400002 and
DOCMNT_CATGRY_CD : 00000002 and 00000003

However in the 9.1 Environment the same target values -> DCMNT_TYPE_CD : 00400002 and DOCMNT_CATGRY_CD : 00000003 is the only value that is getting loaded in to the table.
In the transformer stage --> we have provided the following derivation
If (UStringToString(lkread_Document.SOURCE_TABLE))='DOP' Then '00400001' Else '00400002', is applied in both the environment.

Can anyone share your thoughts whether UString to String has an issue in 9.1 environment

[chulett]

So it's always taking the else path? Are you sure you need that function, meaning what happens if you remove it from the derivation?

[ray.wurlod]

What else is different? For example, how is APT_STRING_PADCHAR set in each environment?