tPersonator Standard properties

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.

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 tPersonator output schema.

Important: When an input column is not defined in the Input mapping table, the corresponding output columns are empty.

• Check action: Standardizes the data and ensures that they are valid. This action analyses each data separately. For example, if the zip code does not match the city, the Check action corrects it, without impacting the other data.
• Verify action: Ensures that the different data are associated with each other. This action analyses the data as a whole. For example, if you perform this action on the addresses, the Verify action verifies whether the address is associated with the same name, phone and email in other databases.
• Move action: Retrieves the last address. The database must at least contain the last name or company name and an address.
• Append action: Adds missing data.

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.

• Definitely full: Select to treat the name in this order: first name, middle name, last name, regardless of formatting or punctuation.
• Very likely full: Select to treat the name in this order: first name, middle name, last name, unless the order is indicated by formatting or punctuation.
• Probably full: Select to let the statistical logic determine the name order, with a bias toward this order: first name, middle name, last name.
• Varying: Select to let the statistical logic determine the name order, with no bias toward either name order.
• Probably inverse: Select to let the statistical logic determine the name order, with a bias toward this order: last name, middle name, first name.
• Very likely inverse: Select to treat the name in this order: last name, middle name, first name, unless the order is indicated by formatting or punctuation.
• Definitely inverse: Select to treat the name in this order: last name, middle name, first name, regardless of formatting or punctuation.
• Mixed first name: Select if the last name misses. Name field must only contain prefixes, first name and middle name.
• Mixed last name: Select if the first and middle names miss. Name field must only contain last names and suffixes.

• Parse logic: Select to consider the middle name as part of the last name. This consideration is possible if the middle name is a common last name. In this case, the last name is hyphenated.
• Hyphenated last: Select to consider the second word as part of the last name.
• Middle name: Select to consider the second word as a middle name.

• Formal: Mr. Smith
• Informal: John
• First/Last: John Smith

Genderization policy: Neutral, Conservative, Aggressive. For more information on this option, see theSetting up the Genderization policy parameter of tPersonator .

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 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 jsmith@domain.com.

Update domain: Select to update the domain name if out-of-dated.

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.

Census 2: Select to return more census information.

Geocode: Select to return the geocode.

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...

• Address and zip code
• Address and city or state
• Phone number
• Email
• Full name
• First name and last name

• Address and zip code or address, city and state
• Phone number
• Email
• Full name or last name or first and last names
• Company name

• Address and full name
• Address and first and last names
• Address and company name

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.