Skip to main content
  • EN

During one of my projects I noticed in my counts that I am missing records.

 

Project Image 

As you can see 16k entries enter the requester eand only 13k exit via either port. This is connected to missing keys entering into the requestor

 

I know that I can solve this using a nullattributemapper to change missing into null, or by setting reject null and missing keys to 'Yes' (non-default setting). However the fact that this is largely invisible has me worried.

 

I have also concluded that this behaviour is not consistent. The below workspace has a test setup testing for the behaviour with simple input data. All 4 cases behave as expected. Unless I missed something, I believe this is a bug. If you can confirm, deny or reproduce, it would be highly appreciated 🙂.

 

 

Set the parameter "Reject Null and Missing Keys" to "Yes".

By the way: Very good Workbench to test

Set the parameter "Reject Null and Missing Keys" to "Yes".

By the way: Very good Workbench to test

Thank you for your answer and the compliment:).

 

I know of multiple ways of how to fix the issue, once spotted.

 

It is the 'stealth' and inconsistent behaviour of this issue that I am concerned about.

You are right. Better is "Reject Null and Missing Keys" set default to "Yes". Much better the features going out to "UnmergedRequestor".

Reply


Community Stats

30,162
Posts
114,512
Replies
37,820
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.