I have source data that has multiple records for a single provider_id and also where differences are only due to case. Should I be grouping these records together so that there is only one entry per provider in the provider table?
Think that the CDM is trying to model the real world. It is the same provider regardless of case. You should have only one entry for provider.