DSXchange

Hi,

I have one multi-instace job which is failing due to pre-look condition mistmatch even though the values are matching.

thr condition is
NullToZero(total_row_Amt)=NullToZero(Source_TOT_AMT)
values are
000159981855319403.000= 000159981855319403.000

however when i remove NullToZero function job run successfully
total_row_Amt=Source_TOT_AMT
i could have simply done this but this is Multi-instance job and used across mny sequece so can not risk to change this.

total_row_Amt and Source_TOT_AMT have data type decimal (21,3)
but there source are aggegation of sevel 100 columns have simmilar datatype.


seeking help on this..please let me know for further information.

Thanks and regards,
Devesh

no replies till now

How are you comparing the values

NullToZero(total_row_Amt)=NullToZero(Source_TOT_AMT)
Anything wrong in this?

My understanding is, Int family data type will have the default vaue as 0. So NullToZero dosen't make any value.

Correct me if i am wrong.

DS User

Comparision done in transformer or lookup.

If in transformer,do you use stage variable?

Its Pre-look up condition
so its carried in Look up satge only

The condition should be alright.

Try to set the lookup failure options to continue and view the result in a peak stage - Do you have a lookup match where your condition is true?

I'm wondering if it's imprecision in decimal storage, though your precision and scale look OK for the values you're using. As a test, can you try converting them to string for the purpose of comparison?

Amending Suzanne's suggestion slightly, can you use a reject link and set your Condition Not Met rule to "output"? Again, this is just for test purposes.