DS Version: 12.2.3.1
Normally, the associative match transform takes various group numbers as input to generate a final group number after performing associative match. DS defines group numbers as VARCHAR(10). This works fine.
But in one of our jobs, we are using associative match a bit differently - it takes three fields as inputs for the match: two group numbers (varchar(10)) as well as another field REC_ID which is varchar(25). The job validates fine.
While running the job though, we get the following warnings::
Transform <Associate_MultiSet>: The group id field has an invalid value of "50000000007018043" and will be ignored. The default value is "0".
And so on for a lot of records.
The value "50000000007018043" belongs to the REC_ID field mentioned above.
My guess is that Associative Match is not able to handle an input field that's larger in length than some predefined value (most likely 10). Is this assumption correct? (The error file is pretty big and though I can't be 100% sure, all the warning messages correspond to each record with large input value.)
We are testing the job right now with smaller values in the REC_ID field, and will report back.