Data validation issue in DS 9.1 environment
Posted: Wed Sep 18, 2013 6:18 am
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
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