Avatar

Community Advisor

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