Difference between revisions of "SSIS:Personator:Processing Options"

From Melissa Data Wiki
Jump to navigation Jump to search
(Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa...")
 
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISPersonatorNav
 
|PersonatorTabsCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Personator Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Personator|Overview]]
|-
|[[SSIS:Personator Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Personator:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Personator:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Personator Tabs
|-
|[[SSIS:Personator:Input|Input]]
|-
|[[SSIS:Personator:Actions|Actions]]
|-
|[[SSIS:Personator:Processing Options|Processing Options]]
|-
|[[SSIS:Personator:Output|Output]]
|-
|[[SSIS:Personator:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:Personator:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Personator:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}





Revision as of 23:56, 9 November 2015

← SSIS:Data Quality Components

Personator Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
Personator Tabs
Input
Actions
Processing Options
Output
Pass-Through Columns
Output Filter
Result Codes
Result Codes



SSIS PR ProcessingOptions.png

Verify and Append Options

Used to set which piece of information to use as the primary point of reference when appending data.

  • Auto
(Default) First uses Address, if available, followed by Phone if no Address is available, and lastly Email if neither Address nor Email are available.
  • Address
Uses Address as the primary point of reference.
  • Phone
Uses Phone as the primary point of reference.
  • Email
Uses Email as the primary point of reference.


Name Options

Name Hint

  • Varying
(Default) If necessary, statistical logic will be employed to determine name order, with no bias toward either name order.
  • Definitely Full
Name will always be treated as normal name order, regardless of formatting or punctuation.
  • Very Likely Full
Name will be treated as normal name order unless inverse order is clearly indicated by formatting or punctuation.
  • Probably Full
If necessary, statistical logic will be employed to determine name order, with a bias toward normal name order.
  • Probably Inverse
If necessary, statistical logic will be employed to determine name order, with a bias toward inverse name order.
  • Very Likely Inverse
Name will be treated as inverse name order unless normal order is clearly indicated by formatting or punctuation.
  • Definitely Inverse
Name will always be treated as inverse name order, regardless of formatting or punctuation.
  • Mixed First Name
Name field is expected to only contain prefixes, first, and middle names.
  • Mixed Last Name
Name field is expected to only contain last names and suffixes.

Middle Name Logic

Determines the handling of middle names.

  • Parse Logic
(Default) Middle names that are typically last names are considered to be part of a hyphenated last name.
  • Hypenated Last
The middle word is assumed to be part of the last name. For Example: "Matthew Edward Jones" is treated as "Matthew Edward-Jones."
  • Middle Name
The middle word is assumed to be a middle name. For example: "Matthew Svensson Jones." "Svensson" would be considered a middle name instead of part of the last name.

Salutation Format

Sets the salutation format for the response.

  • Formal
(Default) Mr. Smith
  • Informal
John
  • First Last
John Smith
Gender Population
Default is Mixed. Sets the gender balance of the source data, either predominantly Male, Female, or Mixed (evenly split).
Gender Aggression
Default is Neutral. Sets how aggressive genderization is for neutral first names, either Neutral, Conservative, or Aggressive.
Correct First Name
Checked by default. If checked, allows common spelling corrections for the First Name field.
Standardize Company Name
Checked by default. If checked, the Company Name field will be returned with standard abbreviation, capitalization, and punctuation rules applied.


Address Options

Diacritics
Default is auto. If on, French language characters will be returned.
Advanced Address Correction
AAC uses the Full Name/Company Name input to perform more advanced address correction.
USPS Preferred City
Default is off. For every city in the United States, there is an official name that is preferred by the U.S. Postal Service. There may be one or more unofficial or “vanity” names in use. Normally, Personator Component allows you to verify addresses using known vanity names. If Preferred City is on, the preferred city name will be substituted for all vanity names when it verifies an address.


Phone Options

Phone Format
Choose one of six different available phone formats:
  • (800) 800-6245: (Default) Parenthesis with dash.
  • (800) 800 6245: Parenthesis with space.
  • 800 800 6245: Spaces.
  • 800-800-6245: Dashes.
  • 800.800.6245: Periods.
  • 8008006245: No space.


Email Options

Database Look up
Checked by default. If checked, verification of domain names will be attempted using a database of valid domains.
Standardize Casing
Checked by default. If checked, all letters in the Email field will be changed to lower case before any checking occurs.
Correct Syntax
Checked by default. If checked, the syntax of the Email field will be corrected.
Update Domain
Checked by default. If checked, determines whether the domain name is out of date and updates it.