Bookshelf Home | Contents | Index | Search | PDF |
Fundamentals > Working with Data > Data Quality >
Data Cleansing
Data cleansing fixes inaccurate and inconsistent data for new or modified account, contact, and prospect records. The data is fixed as follows:
Address Correction
Addresses are stored in a consistent format. For example, 1855 South Grant Street, San Mateo, CA 94401 becomes 1855 S. Grant St., San Mateo, CA 94401-3256.
Standardization
Names of contacts, accounts, and prospects are stored in a consistent format. For example, Siebel Systems, Incorporated becomes Siebel Systems, Inc.
Capitalization
Names and addresses are converted to mixed case, all lowercase, or all uppercase. For example, john smith becomes John Smith.
Truncation
Any hyphenated names in the First Name field are truncated so that only one name is stored in the field. For example, Jean-Paul becomes Jean.
Bookshelf Home | Contents | Index | Search | PDF |
Fundamentals Published: 14 August 2003 |