DSXchange

Hi,

We have requirement to join the columns having HASH value (these hash values have been computed by checksum).

First I tried by 'hash Partition' and sort on this column (which has hash value) from both side of join but all the records do not match. But I expected all the records should be matched as data in source and target are same.

I ran stages in sequential manner as well but still I do not have all the records matched.

If I do join on any normal column/value then join works fine but when I tried to join on column having hash value then I have issue.

Please any suggest what could be the issue?

Thanks.

If the checksum value is different then it seems that the values are different or the data type is not identical or any padding is present while calculating the checksum. Also before join, you need to make sure that hash column has same metadata to get correct joins.

Since you are not getting the correct result while running in sequential mode, I think the issue is while calculating the check sum.

Hi,

I checked the checksum values and it is same what ever is in target. Also if DataStage generates different checksum for same value then it should not be used.

Thanks.

It does not generate different checksum for the same value if the data type is identical as well including unicode.