DataFlux Data Management Studio 2.5: User Guide

Distributed County Node

You can add a Distributed County node to a data job to offload processing of county data to a machine other than the one running the current DataFlux Data Management Studio job. This node is particularly useful when running on a DataFlux Data Management Server because it offers a large performance increase by eliminating the overhead of connecting to the county reference database when starting a real-time service. The node also enables you to open many County lookup services at once. Previously, a memory limitation prevented multiple services from being opened.

Use the Distributed County node to match information from the phone and geocode reference databases with the Federal Information Processing Standard (FIPS) codes in your data to calculate several values. The FIPS code is a five-digit number assigned to each county in the U.S. by the Census Bureau. The first two digits are the state code and the last three digits are the county number.

Note: To use this node you must have DataFlux Data Management Server: Basic installed and licensed. For additional information about DataFlux Data Management Server: Basic installation and configuration please refer to the DataFlux Data Management Server: Basic Reference Guide. After you have installed and configured DataFlux Data Management Server: Basic, you must add the following key and value to the app.cfg file:

DFCLIENT/CFG = <INTELLISERVER CLIENT CONFIGURATION FILE>

For example:

DFCLIENT/CFG = C:\Program Files\DataFlux\dfIntelliServer\etc\dfclient.cfg

To use this node you must have, or be able to create, FIPS codes in your data.

Once you have added the Distributed County node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

FIPS Input Field - Enables you to select the field in your data that contains the FIPS code. The FIPS code is a five-digit combination of the State FIPS and the County FIPS codes.

The Output fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

Additional Outputs - Displays the Additional Outputs dialog. This dialog enables you to specify the fields that you can make available to the next node in your data job.

Override Server - Enables you to override the default connection to the dfIntelliServer specified in the dfclient.cfg file. (See the dfIntelliServer Reference Guide for more information about configuration settings). If you want to override the default server setting and perform the area code lookup on a different dfIntelliServer instance, you can specify the server name in the Override Server field and port number on this dialog.

You can access the following advanced properties by right-clicking the Distributed County node:

• INPUT_FIPS
• OUTPUTS
• OVERRIDE_SERVER
• PASSTHRU