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?
Clint_Richardson (Clint Richardson) #1
DTorok (Don Torok) #2
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 (Clint Richardson) #3