- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
0 Likes
Total Likes