Dictionary File Type Summary

The following table contains a list of the steps that require dictionary files and details on their use.

Step	Filename Property	Dictionary File Type	Description
Update Gender	firstNameRatioLookupFileName	IndexedTableLookup	File contains numbers only. Indexed by names. For more information, see Update Gender Step Dictionary Files.
Update Gender	surnameRatioLookupFileName	IndexedTableLookup	File contains numbers only. Indexed by surnames.
Validate Email	tldLookupFileName	StringLookup	File contains all top-level domains in uppercase without dots.
Validate Phone Number	idcLookupFileName	StringLookup	File contains all known IDCs.
Validate Phone Number	provLookupFileName	StringLookup	File contains prefixes of known Telcos.
Transform Legal Forms	legalFormsLookupFileName	IndexedTableLookup	File contains original values with their replacements. Indexed by the original values.
Validate In Res	databaseFile	IndexedTableLookup	File contains reference data of companies. Indexed by company registration number.
Convert Phone Numbers	conversionTableFileName	IndexedTableLookup	File contains original prefixes with patterns to form a number in the new format. For more information, see Convert Phone Numbers Step Dictionary Files.
Guess Name Surname	firstNameLookupFileName	MatchingLookup	File contains known names.
	lastNameLookupFileName	MatchingLookup	File contains known surnames.
	multiFirstNameLookupFileName	MatchingLookup	File contains known multi-word names.
	multiLastNameLookupFileName	MatchingLookup	File contains known multi-word surnames.
Intelligent Swap Name Surname	firstNameLookupFileName	MatchingLookup	File contains known names.
Intelligent Swap Name Surname	lastNameLookupFileName	MatchingLookup	File contains known surnames.
Strip Titles	titleLookupFileName	IndexedTableLookup	File contains matching values with their replacements for known titles. Indexed by matching value.
Swap Name Surname	firstNameLookupFileName	MatchingLookup	File contains known names. This step is deprecated. Use the Intelligent Swap Name Surname step instead.
Swap Name Surname	lastNameLookupFileName	MatchingLookup	File contains known surnames. This step is deprecated. Use the Intelligent Swap Name Surname step instead.
Validate Vat Id	foLookupFileName	IndexedTableLookup	File contains numbers and names of known tax offices. Indexed by numbers.
Validate Vat Id	cnLookupFileName	IndexedTableLookup	File contains known company registration numbers and company names. Indexed by numbers.
Validate Vin	wmiFileName	IndexedTableLookup	File contains known WMI codes as keys and patterns to match VINs in a second dictionary file. For more information, see ValidateVINAlgorithm Dictionary Files.
Validate Vin	vinInfoFileName	IndexedTableLookup	File contains the following columns: patterns for matching input VIN, manufacturer, car model, year that VIN was issued, position of CRC number, and position of year number. Indexed by matching pattern.
Validate SKRZ	districtLookupFileName	IndexedTableLookup	File contains Slovak district codes and names. Indexed by district codes.
Apply Replacements	replacementsFileName	IndexedTableLookup	File contains original values with their replacements. Indexed by original values.
String Lookup	lookupFileName	StringLookup	File contains a list of strings from which to look up.
Selective Res Lookup	fileName	SelectiveMatchingLookup	File contains reference data of companies. This includes real and matching values of company names, company registration numbers, and an additional optional field.
Table Matching	indexTableFileName	IndexedTableLookup	File contains table from which to look up data. Indexed by keys used for looking up data.
Experimental Exclude Spaces	databaseFile	StringLookup	File contains list of known words.
Anonymizer	nameLookupFileName	IndexedTableLookup	File contains replacement names (first names and surnames) written only in uppercase. Indexed by original values in uppercase.

iWay Software