Difference between revisions of "SSIS:IP Locator:Output Filter"

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...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISIPLocatorNav
 
|IPLocatorTabsCollapse=
{| 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;"|'''IP Locator Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:IP Locator|Overview]]
|-
|[[SSIS:IP Locator Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:IP Locator:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Community|Community]]
|-
|[[SSIS:IP Locator:Advanced Configuration#On-Premise|On-Premise]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Dedicated Cloud|Dedicated Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|IP Locator Tabs
|-
|[[SSIS:IP Locator:Input/Output|Input/Output]]
|-
|[[SSIS:IP Locator:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:IP Locator:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Enterprise Solutions#SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}




Line 58: Line 14:
The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box.
The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box.


*[[Returned Result Codes:Enterprise Solutions#SSIS|Returned Result Codes]]
*[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]




Line 71: Line 27:
:#IP Address Found in Database
:#IP Address Found in Database
:#IP Address Unknown
:#IP Address Unknown
:#IP Address is a proxy
:#IP Address was empty or not well formed
:#IP Address was empty or not well formed
:#IP not Initialized
:#IP not Initialized

Latest revision as of 21:34, 28 July 2017

← SSIS:Data Quality Components

IP Locator Navigation
Overview
Tutorial
Advanced Configuration
Community
On-Premise
Melissa Data Cloud
Dedicated Cloud
IP Locator Tabs
Input/Output
Pass-Through Columns
Output Filter
Result Codes
Result Codes



SSIS IP OutputFilter.png

The IP Locator Component will output records in up to four streams. The Output Filter tab allows you to control which records go to which stream. Names and usage can be done in any manner. Filters are evaluated from the top down.


Result Codes

The output status of a record is returned via result codes returned by the underlying objects. The Component will combine them into a single, comma-delimited string and write them to the field mapped here. New field names can be created by typing the name into the Output Results Code box.


Output Filter

Select a filter to determine which records will be directed to a particular output stream. A custom filter may be created based on individual need, each pin filters the records in a cascading effect, where the results code is compared against the first expression (Pin 1) and then compared against Pin 2, and so on.

No Filter
All records are written to a single output stream.
Pre-built Filter
The Component comes with several pre-built filters for common applications:
  1. IP Address Found in Database
  2. IP Address Unknown
  3. IP Address is a proxy
  4. IP Address was empty or not well formed
  5. IP not Initialized
Custom Filter
Records matching the filter will be directed to the designated file.
For more information, see Custom Output Filters below.


Custom Output Filters

Custom rules are an advanced subject. You should be comfortable with Boolean operations before using custom rules in a production environment.

For more information see Custom Output Filters.