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?
Does provider table need one entry per provider?
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.