Lookup_1,0: Input record has no lookup match. Warning

[Minhajuddin]

Hi,

Please help me fix this warning


Lookup_1,0: Input record has no lookup match.


I have a job in which I have a

Code: Select all

                         Oracle (Sparse Lookup)
                             |
                             |
                             |
                             |
                             |
                             V
Dataset---------> Lookup------------>Dataset

Thank you

[karrisuresh]

Hi
I guess the source records r not matching with look-up
and can I know y did opted for sparse look-up(Is the look-up data volume very high)
check with 1 or 2 matching records from the source then u should not get this warning

Hi,

Please help me fix this warning


Lookup_1,0: Input record has no lookup match.


I have a job in which I have a

Code: Select all

                         Oracle (Sparse Lookup)
                             |
                             |
                             |
                             |
                             |
                             V
Dataset---------> Lookup------------>Dataset

Thank you

[Minhajuddin]

Hi
I guess the source records r not matching with look-up
and can I know y did opted for sparse look-up(Is the look-up data volume very high)
check with 1 or 2 matching records from the source then u should not get this warning

Thank you,

We are using Sparse lookup because the reference data is huge

And you are right in saying that it's throwing up this warning because there is no match found.

But this is expected, So how do you think we can fix it. Any setting?

[Minhajuddin]

And I forgot to mention one more thing.
After the warning.
The job is throwing up a fatal error too.

Lookup_1,0: Input record has no lookup match.

[DSguru2B]

Is'nt there an option in the enterprise stage, that disables sparse lookup warnings?

[Minhajuddin]

Thank you guys,

I didn't check the constraint Icon. It's here I found the Lookup fail condition setting.

Thank you once again.