Topic
No replies
SystemAdmin
SystemAdmin
160 Posts
ACCEPTED ANSWER

Pinned topic Join stage not recognising match

‏2007-01-15T13:31:34Z |
I have a parallel job wherein I am expected to check whether a record in source data contains valid data.
The format of the record is as follows:
ACCESSID BIGINT 18 NOT NULL
USERID VARCHAR 6 NOT NULL
PURPOSEID SMALLINT 5 NOT NULL
CLIENTID INTEGER 10 NOT NULL
MASTERID INTEGER 10 NOT NULL

Now, I have to check whether the userid, purposeid, clientid and masterid stated in this source data is present in lookup tables, and have used join stage (left outer join mode) to check the same.
Initially, to check whether the job worked for valid data combinations, I populated the source table with values from the lookup tables themselves. However, despite doing this, the output shows that there is no match, and all records in source are rejected, when the expected result is that all be accepted as valid.

Could anyone tell me what may possibly be the problem?