|
The Hash Table Data Object
Hash tables are very fast key - value pairs that are organized based on the hash code of the key. They are basically index organized tables. When you load a Hash table in BlueSky Integration Studio it saves the information into a file that you can later access in any other design job. When the job runs, the highly optimized hash table is pre-loaded into memory giving you blazing fast lookups! Hash tables might sound a little more complex than using typical databases or files, but they are just as easy to use as any other data object in BlueSky Integration Studio. Don't ignore them, they can literally increase the speed of your job 100 times or more!
*Note: You must define at least one column in the ColumnLayout as a Key field.
Properties
Action |
Describes the action to take for output streams. Ignored for input streams. Valid options are:
| ||||||||||||||
Alias |
Alias identifier. Aliases are used on all design objects to simplify coding and to ensure each object has a unique identifier. | ||||||||||||||
ColumnLayout |
The column layout (or file structure) of the table. Click on the Ellipse (...) button to fill in the column layout, or select an existing column layout from the repository. | ||||||||||||||
Comments |
Comment area to give descriptive text about the data object and its purpose. | ||||||||||||||
Filename |
The filename of the hash file you want to read or write. This represents the filename only with no Path. Use the Path property to specify the files location. You can use any filename you would like, however it is best to use the .ht file extension to distinguish the file as a hash table. (Example: myfile.ht) | ||||||||||||||
KeyCaseType |
CaseSensitive\CaseInSensitive: describes whether or not the key is case sensitive on lookups. For instance, if a record is read in with a key column value equal to "Matthew", but the key in the Hash table equals "MATTHEW", the record will not match if the property is set to CaseSensitive. | ||||||||||||||
Name |
Descriptive name for this object. You can enter any text to describe the object | ||||||||||||||
Path |
The directory Path to the hash file. Click the ellipse button (...) on the property to browse the directory folders on the server you are accessing. The Filename and Path properties are identified as two separate properties to give added flexibility when Using Parameters. (Example: C:\MyFileFolder\) | ||||||||||||||
TextEncoding |
Text encoding gives you the capability to handle different types of encoded text files such as ASCII, UTF and Unicode.
|
© 2003 - 2007 Relational Solutions, Inc. - All rights reserved