Difference between revisions of "SSIS:Personator:Input"

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



The input tab configures the fields that will be used for the Personator Component. Existing field names can be selected using the drop-down boxes. New field names can be created by typing the name into the box.

SSIS PR Input.png

Apply Free Form
Check this option to use the Free Form input.

Input Free Form

Free Form
Enter the whole address as one line, and the Personator component will attempt to identify, parse, and reorganize the input data.


Input Name Fields

Full Name
This field can contain a full name.
First Name
The given (First) name.
Last Name
The family (Last) name.


Input Phone/Email Fields

Phone
The telephone number.
Email
The email address.


Input Address Fields

Company Name
The company associated with the name/address.
Address Line 1
The first line of street address information. It may also contain secondary address information such as suite and private mailbox numbers.
Address Line 2
The second line of street address information, if any.
City
The city.
State
The state.
Zip
The postal (ZIP) code.
Country
The country. Personator currently supports the U.S. and Canada.