DSXchange

Hi,

I'm converting all the basic transformers in our jobs to Parallel Transformers.

In one of stage variables SvMemberID2 of a job,i see the following conversion

ConvertMember1toMember2(CLIENT_ID:',' :MEMBER_ID:',': PERSON_CODE)

Where the input datatype for all the three columns used here are

CLIENT_ID - Varchar(15)
MEMBER_ID - Varchar(18)
PERSON_CODE - Varchar(3)

and the datatype of the above stage variable is Varchar(18)

while mapping the above stage variable to the output coulmn they had used the following derivation


If SvMemberID2 = '-1' Then trimb(MEMBER_ID) Else trimb(SvMemberID2)

The datatype of the output column to which the above derivation is applied is

MemberID2 - Char(18)


Please help me in understanding, what they are trying to achieve by using the above transformation.

Thanks is Advance.

Welcome aboard.

The answer is "no idea". ConvertMember1ToMember2() is a BASIC function written in-house at your site. Without knowing what that routine does, we are in no position to understand what -1 might mean.

Peruse the code of the routine (post it if that doesn't violate any non-disclosure agreement) to figure out what's happening.