These properties are used to configure tPersonator running in the Standard Job framework.
The standard tPersonator component belongs to the Data Quality family.
|Schema and Edit schema||
A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component.
Click Sync columns to retrieve the schema from the previous component connected in the Job.
Select the Schema type:
Click Edit schema to make changes to the schema. If the current schema is of the Repository type, three options are available:
View schema: choose this option to view the schema only.
Change to built-in property: choose this option to change the schema to Built-in for local changes.
Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion. If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the Repository Content window.
The only supported data type is String.
The output schema contains read-only columns. For more information, see the list of the output columns.
|Input mapping|| Associate the Personator field with the Input column.
Important: When an input column is not defined in the Input mapping table, the corresponding output columns are empty.
|Actions||Select the actions to perform:
|Centric hint||Available if you select Append action or Verify
Select one reference data:
|Append options||Available if you select Append action.
Select one action:
auto, on or off. Set to on
to return the French characters. If set to auto, those characters are returned if present in your
Advanced address correction: Select to perform an advanced correction of the address. It uses the full name or company name and can correct or append house number, street name, city, state and zip code.
Use preferred city: Select to use the city name preferred by the postal services.
Genderization policy: Neutral, Conservative, Aggressive. For more information on this option, see the table of results.
To see the preceding Name options information in the output columns, select the Name details check box in Miscellaneous outputs.
Correct first name: Select to correct the spelling of the first name.Standardize company: Select to apply title cases and abbreviate the company name. For example, melissa data corporation is replaced by Melissa Data Corp..
lookup: Select to verify the domain names using a
database of valid domains.
Standardize case: Select to lowercase the email characters before any action.
Correct syntax: Select to correct the syntax of the email. This option supports simple email syntax: local part + @ + domain + ‘.’ + top-level domain. For example, jsmith@domain,coj is replaced by email@example.com.
Update domain: Select to update the domain name if out-of-dated.
(Default): Select to return the basic address. This setting is always enabled.
Address details: Select to return the detailed address.
Plus4: Select to return the +4 code.
Private mailbox: Select to return the private mail box number. These mail boxes are the private mail boxes in commercial mail receiving agencies.
Suite: Select to return the apartment number.
Parsed address: Select to return the address details.
Select to return census information.
Census 2: Select to return more census information.
Geocode: Select to return the geocode.
details: Select to return a string containing all the
results of the demographics. Commas delimit the results.
Name details: Select to return the name details such as the gender, salutation...
Parsed email: Select to return the email details such as the domain name, mailbox name...
Parsed phone: Select to return the phone number details such as the extension, prefix...
|Check||The database must at least contain one of the
|Verify||The database must at least contain two of the
|Move||The database must at least contain one of the
|Append||The mandatory inputs depend on the data to append.
To append a name or company name, the database must at least contain one of the following:
To append an address, the database must at least contain one of the following:
To append a phone number, the database must at least contain one of the following:
To append an email, the database must at least contain one of the following:
Select this check box to gather the Job processing metadata at the Job level as well as at each component level.
To enter a key, click the […] button next to the field.If you have no license key, contact Melissa Data.
|Number of retries||Define the number of retries before the Job fails.|
|Timeout in seconds||Define the timeout time period.|
|Cache directory||Browse the cache directory.|
|Batch request size (1-100)||Define the number of messages to be delivered in each batch.|
|Multithreading||Select to use more than one thread in the same job to handle the response from the Melissa data service.|
|Thead count (1-10)||Define the maximum number of threads.|
|Show debug console output||Select to show the debug console output.|