Cartesian product in workflow | Community
Skip to main content
Milan_Vucetic
Milan_Vucetic
Level 9
February 3, 2020
Solved

Cartesian product in workflow

  • February 3, 2020
  • 1 reply
  • 4309 views

Hi all,

 

we noticed a bigger number in output then in input for some SMS recurring deliveries.

After checking, a cross join is performed for customers with more mobile phones and that is the reason for bigger number. (We have several records for the same recipient with different mobile phones which customer poses in recipient table.)

 

I am trying to find out why is used the cross join here as target mapping is done on mobile number level.

Any idea?

 

Regards,

Milan

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

 

Recipients exist as duplicates in recipient table for each of their phones?

NB not cross join- recipients exist on left side for the numbers.

 

Thanks,

-Jon

1 reply

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
February 3, 2020

Hi,

 

Recipients exist as duplicates in recipient table for each of their phones?

NB not cross join- recipients exist on left side for the numbers.

 

Thanks,

-Jon

Milan_Vucetic
Milan_VuceticAuthor
Level 9
February 3, 2020

Hi @jonathon_wodnicki,

well primary key is unique but there are customers with the same name/last name with different mobile phones. Generally, these are not duplicates as phone number is different. In output transition cross join is performed: If we have customer with 4 different numbers , we got 16 records (first 4 records with one number, second 4 records with other number, etc).

 

Anyway, output count should not be greater than input.

 

Regards,

Milan

Terms & ConditionsAccessibility statement

Loading footer...