Getting to Third Normal Form (or close enough) | Community
Skip to main content
Robb_Barrett
Robb_Barrett
Level 10
May 4, 2016
Question

Getting to Third Normal Form (or close enough)

  • May 4, 2016
  • 1 reply
  • 1166 views

OK, so this is going to attract the geeks. What have you done to get your data to 3NF? In particular, I'm wondering about fixing up company names. I work in healthcare. I like to use the example of the number of ways one could spell out St. John's Hospital.  Now, we know that email domains are typically wonderful for getting an accurate spelling but how to you normalize company names off of the email domain? Marketo doesn't excel at data management.

Any suggestions for normalizing data? Even 1st or 2nd normal form is better than pure free-form text.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Grégoire_Miche2
Grégoire_Miche2
Level 10
May 4, 2016

Hi Robb,

A couple of thoughts: we usually use a combination of email domain and postal/zip code to identify the company in a account DB. This can be done in SFDC with a trigger using the account DB which is itself normalized. In SFDC, the interesting point is that you can link the lead to the account with a lookup field (meaning the link is the ID) and make sure that from then the lead company name always reflect the account name (with workflows and process builders and/or triggers). This is the closer I think of the 3NF.

Not as good but may be easier to implement : this can also be done with a webhook that will to the lookup in an external DB, but it's harder to keep the 2 in sync (if the account name changes, how do you make sure all the leads are updated ?)

Finally, I read a post a while ago, from @Dan Stevens​ about lookup munctions that may enable this kind of lookup search as well.

-Greg

    Terms & ConditionsAccessibility statement

    Loading footer...