Does provider table need one entry per provider?

[Clint_Richardson]

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?

[DTorok]

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.

[Clint_Richardson]

Thank you!