Split Options - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The Split process offers a variety of methods for partitioning your output files. For each method, there are one or more parameters that further define the process. The appropriate parameters are added to the Split Options window when you select the partition method. The following table describes the settings and the associated parameters:

Partition Method

Description

Round robin number

Split the file by number of rows. If you select this method, specify the round robin number in the Number of records to write to each file field. See Splitting Files for an example.  You also need to specify the Number of output files you want the process to create.

Round robin keys

Split the file by attribute. If you select this method, you can define additional Match Keys. Specify the Number of output files you want the process to create. See Splitting Files for an example.

Note: The input file should be sorted by the value of the attribute used for splitting. For example, if you want to split a file by the Country Code attribute and you have 4 country codes, the file should be sorted by Country Code . Then specify the number of output files to be 4 and use Country Code as Match Key.

Ranges

Split the file by a range of values. If you select this method, the Add New Rang e button appears in the window. Click the button and enter the start and ending values of the range. You can define multiple ranges. Also, specify the Number of output files you want the process to create. Requires a Match Key definition.

Ranges stable

Split the file by attribute and attribute length which are established by the Match Key. You also need to specify the Number of output files you want the process to create.

Rows per segment

Split the file by segment, where the segment is a specified number of rows. If you select this method, define the number of rows in a segment in the Number of rows to write to each file field.

Bytes per segment

Split the file by segment, where the segment is a specified number of bytes. If you select this method, define the number of bytes per segment in the Number of bytes to write to each file field.

Segments per file

Split the file by segment, where the number of segments is determined by the number of output files specified.

Conditional split

Split the file according to the conditions you define. If you select this method, you need to define the conditions you want met for the row to be written to a file. See Setting Up a Conditional Split.