Oracle Warehouse Builder Java API Reference
10g Release 1 (10.1)

B12155-01

oracle.owb.mapping
Class PropDefMiscLogical

java.lang.Object
  |
  +--oracle.owb.mapping.PropDefCommon
        |
        +--oracle.owb.mapping.PropDefMiscLogical

public class PropDefMiscLogical
extends PropDefCommon

PropDefMiscLogical defines all misc logical properties.


Field Summary
static java.lang.String ML1$KEY_COLUMNS_STRING
          Miscellaneous logical property of type ML1.
static java.lang.String ML1$KEY_NAME_STRING
          Miscellaneous logical property of type ML1.
static java.lang.String ML1$KEY_TYPE_STRING
          Miscellaneous logical property of type ML1.
static java.lang.String ML1$REFERENCED_KEYS_STRING
          Miscellaneous logical property of type ML1.
static java.lang.String ML10$EXPRESSION_STRING
          Miscellaneous logical property of type ML10.
static java.lang.String ML2$ADDRESS_ADDRESS_LINE_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_ALLOW_DIFFERING_SECONDARY_ADDRESSES_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_LAST_LINE_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_MATCH_ON_ADDRESS_LINE_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_MATCH_ON_BLANK_SECONDARY_ADDRESSES_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_MATCH_ON_LAST_LINE_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_MATCH_ON_STREET_OR_PO_BOX_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$ADDRESS_ROLES_ML7LIST
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$CONDITIONS_ML5LIST
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$CUSTOM_RULE_STRING
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$DESCRIPTION_STRING
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_CROSS_MATCH_FIRM1_AND_FIRM2_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_MATCH_ON_ABBREVIATIONS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_MATCH_ON_ACRONYMS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_MATCH_ON_PARTIAL_NAMES_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_MATCH_ON_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_ROLES_ML8LIST
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$FIRM_STRIP_NOISE_WORDS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_DETECT_SWITCHED_NAME_ORDER_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_DETECT_COMPOUND_NAME_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_MATCH_ON_INITIALS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_MATCH_ON_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_MATCH_ON_SOUNDEX_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_MATCH_ON_SUBSTRINGS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_MRS_MATCH_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_FN_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_LN_DETECT_MISSING_HYPHEN_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_LN_MATCH_HYPHENATED_NAMES_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_LN_MATCH_ON_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_LN_MATCH_ON_SOUNDEX_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_LN_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_MN_MATCH_ON_INITIALS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_MN_MATCH_ON_SIMILARITY_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_MN_MATCH_ON_SOUNDEX_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_MN_MATCH_ON_SUBSTRINGS_BOOLEAN
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_MN_SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$PERSON_ROLES_ML6LIST
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$TOTAL_WEIGHT_SCORE_INTEGER
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$TYPE_STRING
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$USAGE_STRING
          Miscellaneous logical property of type ML2.
static java.lang.String ML2$WEIGHTS_ML4LIST
          Miscellaneous logical property of type ML2.
static java.lang.String ML3$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$ATTRIBUTES_ML9LIST
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$COPY_ATTRIBUTE_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$CUSTOM_TEXT_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$DESCRIPTION_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$MATCH_ID_SEQUENCE_MODULE_NAME_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$MATCH_ID_SEQUENCE_NAME_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$MIN_MAX_ATTRIBUTE_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$MIN_MAX_TYPE_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$RANK_RULES_ML10LIST
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$SEQUENCE_MODULE_NAME_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$SEQUENCE_NAME_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML3$TYPE_STRING
          Miscellaneous logical property of type ML3.
static java.lang.String ML4$BLANK_SCORE_INTEGER
          Miscellaneous logical property of type ML4.
static java.lang.String ML4$WEIGHT_ATTRIBUTE_STRING
          Miscellaneous logical property of type ML4.
static java.lang.String ML4$WEIGHT_SCORE_INTEGER
          Miscellaneous logical property of type ML4.
static java.lang.String ML5$ALGORITHM_STRING
          Miscellaneous logical property of type ML5.
static java.lang.String ML5$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML5.
static java.lang.String ML5$BLANK_MATCHING_STRING
          Miscellaneous logical property of type ML5.
static java.lang.String ML5$SIMILARITY_SCORE_INTEGER
          Miscellaneous logical property of type ML5.
static java.lang.String ML6$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML6.
static java.lang.String ML6$TYPE_STRING
          Miscellaneous logical property of type ML6.
static java.lang.String ML7$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML7.
static java.lang.String ML7$TYPE_STRING
          Miscellaneous logical property of type ML7.
static java.lang.String ML8$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML8.
static java.lang.String ML8$TYPE_STRING
          Miscellaneous logical property of type ML8.
static java.lang.String ML9$ATTRIBUTE_NAME_STRING
          Miscellaneous logical property of type ML9.

 

Fields inherited from class oracle.owb.mapping.PropDefCommon
DEFAULT_BOOLEAN_DOMAIN, DEFAULT_FLOAT_DOMAIN, DEFAULT_INTEGER_DOMAIN, DEFAULT_PROPERTYOWNER_DOMAIN, DEFAULT_STRING_DOMAIN

 

Constructor Summary
PropDefMiscLogical()
           

 

Method Summary
protected static boolean containsKey(java.lang.String type, java.lang.String key)
          containsKey is a boolean checkup to see if this set of property definitions includes the definition for the key.
protected static oracle.owb.mapping.PropSheetImpl getPropSheet(java.lang.String type)
          getPropSheet Retrieve the property sheet of a property type.

 

Methods inherited from class oracle.owb.mapping.PropDefCommon
translate

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

ML9$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML9$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML9. Key name: ATTRIBUTE_NAME.

Description: Record merge rule attribute

See Also:
Constant Field Values

ML6$TYPE_STRING

public static final java.lang.String ML6$TYPE_STRING
Miscellaneous logical property of type ML6. Key name: TYPE.

Description: What role is this attribute? Possible values are: MM_PRENAME, MM_FIRST_NAME_STD, MM_MIDDLE_NAME_STD, MM_MIDDLE_NAME_2_STD, MM_MIDDLE_NAME_3_STD, MM_LAST_NAME, MM_MATURITY_POST_NAME.

See Also:
Constant Field Values

ML6$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML6$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML6. Key name: ATTRIBUTE_NAME.

Description: What is the attribute for this role.

See Also:
Constant Field Values

ML3$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML3$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML3. Key name: ATTRIBUTE_NAME.

Description: Merge Attribute

See Also:
Constant Field Values

ML3$TYPE_STRING

public static final java.lang.String ML3$TYPE_STRING
Miscellaneous logical property of type ML3. Key name: TYPE.

Description: Merge Rule Type. Possible values are:MM_ANY,MM_MATCH_ID,MM_RANK,MM_SEQUENCE,MM_MIN_MAX,MM_COPY,MM_CUSTOM,MM_RECORD_ANY,MM_RECORD_RANK,MM_RECORD_MIN_MAX,MM_RECORD_CUSTOM.

See Also:
Constant Field Values

ML3$DESCRIPTION_STRING

public static final java.lang.String ML3$DESCRIPTION_STRING
Miscellaneous logical property of type ML3. Key name: DESCRIPTION.

Description: Description

See Also:
Constant Field Values

ML3$MIN_MAX_TYPE_STRING

public static final java.lang.String ML3$MIN_MAX_TYPE_STRING
Miscellaneous logical property of type ML3. Key name: MIN_MAX_TYPE.

Description: Select record where attribute is min,max, shortest, longest. Possible values are MM_MIN, MM_MAX, MM_SHORTEST, MM_LONGEST.

See Also:
Constant Field Values

ML3$MIN_MAX_ATTRIBUTE_STRING

public static final java.lang.String ML3$MIN_MAX_ATTRIBUTE_STRING
Miscellaneous logical property of type ML3. Key name: MIN_MAX_ATTRIBUTE.

Description: Selecting attribute for min/max merge rule

See Also:
Constant Field Values

ML3$COPY_ATTRIBUTE_STRING

public static final java.lang.String ML3$COPY_ATTRIBUTE_STRING
Miscellaneous logical property of type ML3. Key name: COPY_ATTRIBUTE.

Description: Copy this merged attribute to merge rule target attribute.

See Also:
Constant Field Values

ML3$SEQUENCE_NAME_STRING

public static final java.lang.String ML3$SEQUENCE_NAME_STRING
Miscellaneous logical property of type ML3. Key name: SEQUENCE_NAME.

Description: Physical sequence name for sequence merge rule.

See Also:
Constant Field Values

ML3$SEQUENCE_MODULE_NAME_STRING

public static final java.lang.String ML3$SEQUENCE_MODULE_NAME_STRING
Miscellaneous logical property of type ML3. Key name: SEQUENCE_MODULE_NAME.

Description: Physical sequence module name for sequence merge rule.

See Also:
Constant Field Values

ML3$MATCH_ID_SEQUENCE_NAME_STRING

public static final java.lang.String ML3$MATCH_ID_SEQUENCE_NAME_STRING
Miscellaneous logical property of type ML3. Key name: MATCH_ID_SEQUENCE_NAME.

Description: Physical sequence name for match id merge rule. This sequence will be used to generate the match id.

See Also:
Constant Field Values

ML3$MATCH_ID_SEQUENCE_MODULE_NAME_STRING

public static final java.lang.String ML3$MATCH_ID_SEQUENCE_MODULE_NAME_STRING
Miscellaneous logical property of type ML3. Key name: MATCH_ID_SEQUENCE_MODULE_NAME.

Description: Physical sequence module name for match id merge rule. This sequence will be used to generate the match id.

See Also:
Constant Field Values

ML3$CUSTOM_TEXT_STRING

public static final java.lang.String ML3$CUSTOM_TEXT_STRING
Miscellaneous logical property of type ML3. Key name: CUSTOM_TEXT.

Description: Implementation text for custom merge rule. Include "BEGIN and END statements.

See Also:
Constant Field Values

ML3$ATTRIBUTES_ML9LIST

public static final java.lang.String ML3$ATTRIBUTES_ML9LIST
Miscellaneous logical property of type ML3. Key name: ATTRIBUTES.

Description: Attributes for record merge rule.

See Also:
Constant Field Values

ML3$RANK_RULES_ML10LIST

public static final java.lang.String ML3$RANK_RULES_ML10LIST
Miscellaneous logical property of type ML3. Key name: RANK_RULES.

Description: Rank rules. Select the record that passes the highest ranked rule.

See Also:
Constant Field Values

ML8$TYPE_STRING

public static final java.lang.String ML8$TYPE_STRING
Miscellaneous logical property of type ML8. Key name: TYPE.

Description: What role is this attribute? Possible values are: MM_FIRM1,MM_FIRM2.

See Also:
Constant Field Values

ML8$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML8$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML8. Key name: ATTRIBUTE_NAME.

Description: What is the attribute for this role?

See Also:
Constant Field Values

ML5$ALGORITHM_STRING

public static final java.lang.String ML5$ALGORITHM_STRING
Miscellaneous logical property of type ML5. Key name: ALGORITHM.

Description: Algorithm of this condition. Possible values are: MM_EXACT, MM_STD_EXACT, MM_SOUNDEX, MM_SIMILARITY, MM_STD_SIMILARITY, MM_PARTIAL_NAME, MM_ABBREVIATION, MM_ACRONYM.

See Also:
Constant Field Values

ML5$BLANK_MATCHING_STRING

public static final java.lang.String ML5$BLANK_MATCHING_STRING
Miscellaneous logical property of type ML5. Key name: BLANK_MATCHING.

Description: How do you want blanks to be handled? Possible values are: MM_MATCH_BOTH_BLANK, MM_MATCH_EITHER_BLANK, MM_NO_MATCH_IF_BLANK.

See Also:
Constant Field Values

ML5$SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML5$SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML5. Key name: SIMILARITY_SCORE.

Description: If this is a similarity condition, what score must the similarity equal or exceed for records to meet the condition?

See Also:
Constant Field Values

ML5$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML5$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML5. Key name: ATTRIBUTE_NAME.

Description: To which attribute does this condition apply?

See Also:
Constant Field Values

ML2$TYPE_STRING

public static final java.lang.String ML2$TYPE_STRING
Miscellaneous logical property of type ML2. Key name: TYPE.

Description: What type of match rule is this? Possible types are: MM_TRUE, MM_FALSE, MM_WEIGHT, MM_CONDITIONAL, MM_CUSTOM, MM_PERSON, MM_FIRM, MM_ADDRESS

See Also:
Constant Field Values

ML2$USAGE_STRING

public static final java.lang.String ML2$USAGE_STRING
Miscellaneous logical property of type ML2. Key name: USAGE.

Description: Is this an active or passive rule? Possible usages are: MM_ACTIVE, MM_PASSIVE.

See Also:
Constant Field Values

ML2$DESCRIPTION_STRING

public static final java.lang.String ML2$DESCRIPTION_STRING
Miscellaneous logical property of type ML2. Key name: DESCRIPTION.

Description: Description of match rule.

See Also:
Constant Field Values

ML2$TOTAL_WEIGHT_SCORE_INTEGER

public static final java.lang.String ML2$TOTAL_WEIGHT_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: TOTAL_WEIGHT_SCORE.

Description: If this is a weight rule, the sum of all weights must be equal to or greater than this score for the records to pass the weght rule.

See Also:
Constant Field Values

ML2$PERSON_DETECT_SWITCHED_NAME_ORDER_BOOLEAN

public static final java.lang.String ML2$PERSON_DETECT_SWITCHED_NAME_ORDER_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_DETECT_SWITCHED_NAME_ORDER.

Description: If this is a person rule, should Warehouse Builder detect the switched name order.

See Also:
Constant Field Values

ML2$PERSON_FN_MATCH_ON_INITIALS_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_MATCH_ON_INITIALS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_MATCH_ON_INITIALS.

Description: If this is a person match rule, should Warehouse Builder match on initials.

See Also:
Constant Field Values

ML2$PERSON_FN_MATCH_ON_SUBSTRINGS_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_MATCH_ON_SUBSTRINGS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_MATCH_ON_SUBSTRINGS.

Description: If this is a person match rule, should Warehouse Builder match on first name substrings?

See Also:
Constant Field Values

ML2$PERSON_FN_MATCH_ON_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_MATCH_ON_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_MATCH_ON_SIMILARITY.

Description: If this is a person match rule, should Warehouse Builder match on first name similarity?

See Also:
Constant Field Values

ML2$PERSON_FN_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$PERSON_FN_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: PERSON_FN_SIMILARITY_SCORE.

Description: If matching in first name similarity, what is the similarity score?

See Also:
Constant Field Values

ML2$PERSON_FN_MATCH_ON_SOUNDEX_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_MATCH_ON_SOUNDEX_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_MATCH_ON_SOUNDEX.

Description: If this is a person match rule, should Warehouse Builder match on first name soundex?

See Also:
Constant Field Values

ML2$PERSON_FN_DETECT_COMPOUND_NAME_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_DETECT_COMPOUND_NAME_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_DETECT_COMPOUND_NAME.

Description: If this is a person match rule, should Warehouse Builder detect compound names?

See Also:
Constant Field Values

ML2$PERSON_FN_MRS_MATCH_BOOLEAN

public static final java.lang.String ML2$PERSON_FN_MRS_MATCH_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_FN_MRS_MATCH.

Description: If this is a person match rule, should Warehouse Builder detect MRS? (For example, should Mrs John Smith match Mrs Smith)

See Also:
Constant Field Values

ML2$PERSON_MN_MATCH_ON_INITIALS_BOOLEAN

public static final java.lang.String ML2$PERSON_MN_MATCH_ON_INITIALS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_MN_MATCH_ON_INITIALS.

Description: If this is a person match rule, should Warehouse Builder match on middle name initials?

See Also:
Constant Field Values

ML2$PERSON_MN_MATCH_ON_SUBSTRINGS_BOOLEAN

public static final java.lang.String ML2$PERSON_MN_MATCH_ON_SUBSTRINGS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_MN_MATCH_ON_SUBSTRINGS.

Description: If this is a person match rule, should Warehouse Builder match on middle name substrings?

See Also:
Constant Field Values

ML2$PERSON_MN_MATCH_ON_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$PERSON_MN_MATCH_ON_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_MN_MATCH_ON_SIMILARITY.

Description: If this is a person match rule, should Warehouse Builder match on middle name similarity?

See Also:
Constant Field Values

ML2$PERSON_MN_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$PERSON_MN_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: PERSON_MN_SIMILARITY_SCORE.

Description: If Warehouse Builder is matching on middle name similarity, what is the similarity score?

See Also:
Constant Field Values

ML2$PERSON_MN_MATCH_ON_SOUNDEX_BOOLEAN

public static final java.lang.String ML2$PERSON_MN_MATCH_ON_SOUNDEX_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_MN_MATCH_ON_SOUNDEX.

Description: If this is a person match rule, should Warehouse Builder match on middle name soundex?

See Also:
Constant Field Values

ML2$PERSON_LN_MATCH_HYPHENATED_NAMES_BOOLEAN

public static final java.lang.String ML2$PERSON_LN_MATCH_HYPHENATED_NAMES_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_LN_MATCH_HYPHENATED_NAMES.

Description: If this is a person match rule, should Warehouse Builder match on hyphenated last name?

See Also:
Constant Field Values

ML2$PERSON_LN_DETECT_MISSING_HYPHEN_BOOLEAN

public static final java.lang.String ML2$PERSON_LN_DETECT_MISSING_HYPHEN_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_LN_DETECT_MISSING_HYPHEN.

Description: If this is a person match rule, should Warehouse Builder detect missing hyphens?

See Also:
Constant Field Values

ML2$PERSON_LN_MATCH_ON_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$PERSON_LN_MATCH_ON_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_LN_MATCH_ON_SIMILARITY.

Description: If this is a person match rule, should Warehouse Builder match on last name similarity?

See Also:
Constant Field Values

ML2$PERSON_LN_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$PERSON_LN_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: PERSON_LN_SIMILARITY_SCORE.

Description: If Warehouse Builder is matching on last name similarity, what is the similarity score?

See Also:
Constant Field Values

ML2$PERSON_LN_MATCH_ON_SOUNDEX_BOOLEAN

public static final java.lang.String ML2$PERSON_LN_MATCH_ON_SOUNDEX_BOOLEAN
Miscellaneous logical property of type ML2. Key name: PERSON_LN_MATCH_ON_SOUNDEX.

Description: If this is a person match rule, should Warehouse Builder match on last name soundex?

See Also:
Constant Field Values

ML2$FIRM_STRIP_NOISE_WORDS_BOOLEAN

public static final java.lang.String ML2$FIRM_STRIP_NOISE_WORDS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_STRIP_NOISE_WORDS.

Description: If this is a firm match rule, should Warehouse Builder strip noise words?

See Also:
Constant Field Values

ML2$FIRM_CROSS_MATCH_FIRM1_AND_FIRM2_BOOLEAN

public static final java.lang.String ML2$FIRM_CROSS_MATCH_FIRM1_AND_FIRM2_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_CROSS_MATCH_FIRM1_AND_FIRM2.

Description: If this is a firm match rule, should Warehouse Builder cross match firm 1 and firm 2?

See Also:
Constant Field Values

ML2$FIRM_MATCH_ON_PARTIAL_NAMES_BOOLEAN

public static final java.lang.String ML2$FIRM_MATCH_ON_PARTIAL_NAMES_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_MATCH_ON_PARTIAL_NAMES.

Description: If this is a firm match rule, should Warehouse Builder match on partial names?

See Also:
Constant Field Values

ML2$FIRM_MATCH_ON_ABBREVIATIONS_BOOLEAN

public static final java.lang.String ML2$FIRM_MATCH_ON_ABBREVIATIONS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_MATCH_ON_ABBREVIATIONS.

Description: If this is a firm match rule, should Warehouse Builder match on abbreviations?

See Also:
Constant Field Values

ML2$FIRM_MATCH_ON_ACRONYMS_BOOLEAN

public static final java.lang.String ML2$FIRM_MATCH_ON_ACRONYMS_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_MATCH_ON_ACRONYMS.

Description: If this is a firm match rule, should Warehouse Builder match on acronyms?

See Also:
Constant Field Values

ML2$FIRM_MATCH_ON_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$FIRM_MATCH_ON_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: FIRM_MATCH_ON_SIMILARITY.

Description: If this is a firm match rule, should Warehouse Builder check firm similarity?

See Also:
Constant Field Values

ML2$FIRM_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$FIRM_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: FIRM_SIMILARITY_SCORE.

Description: Similarity score for firm in Firm Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_ALLOW_DIFFERING_SECONDARY_ADDRESSES_BOOLEAN

public static final java.lang.String ML2$ADDRESS_ALLOW_DIFFERING_SECONDARY_ADDRESSES_BOOLEAN
Miscellaneous logical property of type ML2. Key name: ADDRESS_ALLOW_DIFFERING_SECONDARY_ADDRESSES.

Description: Allow differing secondary addresses to match in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_MATCH_ON_BLANK_SECONDARY_ADDRESSES_BOOLEAN

public static final java.lang.String ML2$ADDRESS_MATCH_ON_BLANK_SECONDARY_ADDRESSES_BOOLEAN
Miscellaneous logical property of type ML2. Key name: ADDRESS_MATCH_ON_BLANK_SECONDARY_ADDRESSES.

Description: Match on blank secondary address in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_MATCH_ON_STREET_OR_PO_BOX_BOOLEAN

public static final java.lang.String ML2$ADDRESS_MATCH_ON_STREET_OR_PO_BOX_BOOLEAN
Miscellaneous logical property of type ML2. Key name: ADDRESS_MATCH_ON_STREET_OR_PO_BOX.

Description: Match on Street or Post Office (PO) Box in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_MATCH_ON_ADDRESS_LINE_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$ADDRESS_MATCH_ON_ADDRESS_LINE_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: ADDRESS_MATCH_ON_ADDRESS_LINE_SIMILARITY.

Description: Check address line similarity in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_ADDRESS_LINE_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$ADDRESS_ADDRESS_LINE_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: ADDRESS_ADDRESS_LINE_SIMILARITY_SCORE.

Description: Similarity score for address line in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_MATCH_ON_LAST_LINE_SIMILARITY_BOOLEAN

public static final java.lang.String ML2$ADDRESS_MATCH_ON_LAST_LINE_SIMILARITY_BOOLEAN
Miscellaneous logical property of type ML2. Key name: ADDRESS_MATCH_ON_LAST_LINE_SIMILARITY.

Description: Check last line similarity in Address Match Rule.

See Also:
Constant Field Values

ML2$ADDRESS_LAST_LINE_SIMILARITY_SCORE_INTEGER

public static final java.lang.String ML2$ADDRESS_LAST_LINE_SIMILARITY_SCORE_INTEGER
Miscellaneous logical property of type ML2. Key name: ADDRESS_LAST_LINE_SIMILARITY_SCORE.

Description: Similarity score for last line in Address Match Rule.

See Also:
Constant Field Values

ML2$CUSTOM_RULE_STRING

public static final java.lang.String ML2$CUSTOM_RULE_STRING
Miscellaneous logical property of type ML2. Key name: CUSTOM_RULE.

Description: Custom Merge Rule

See Also:
Constant Field Values

ML2$WEIGHTS_ML4LIST

public static final java.lang.String ML2$WEIGHTS_ML4LIST
Miscellaneous logical property of type ML2. Key name: WEIGHTS.

Description: Folder containing match weights for the weight match rule.

See Also:
Constant Field Values

ML2$CONDITIONS_ML5LIST

public static final java.lang.String ML2$CONDITIONS_ML5LIST
Miscellaneous logical property of type ML2. Key name: CONDITIONS.

Description: If this is a condition based match rule, what are the conditions?

See Also:
Constant Field Values

ML2$PERSON_ROLES_ML6LIST

public static final java.lang.String ML2$PERSON_ROLES_ML6LIST
Miscellaneous logical property of type ML2. Key name: PERSON_ROLES.

Description: This is a list of roles that describe a person to the person match rule.

See Also:
Constant Field Values

ML2$ADDRESS_ROLES_ML7LIST

public static final java.lang.String ML2$ADDRESS_ROLES_ML7LIST
Miscellaneous logical property of type ML2. Key name: ADDRESS_ROLES.

Description: This is a list of roles that describe an address to the address match rule.

See Also:
Constant Field Values

ML2$FIRM_ROLES_ML8LIST

public static final java.lang.String ML2$FIRM_ROLES_ML8LIST
Miscellaneous logical property of type ML2. Key name: FIRM_ROLES.

Description: This is a list of roles that describe a firm to the firm match rule.

See Also:
Constant Field Values

ML7$TYPE_STRING

public static final java.lang.String ML7$TYPE_STRING
Miscellaneous logical property of type ML7. Key name: TYPE.

Description: What role is this attribute? Possible values are: MM_PRIMARY_ADDR, MM_UNIT_NUM, MM_PO_BOX, MM_DUAL_PRIMARY_ADDR, MM_DUAL_UNIT_NUM, MM_DUAL_PO_BOX, MM_CITY, MM_STATE, MM_POSTAL_CODE, MM_IS_FOUND.

See Also:
Constant Field Values

ML7$ATTRIBUTE_NAME_STRING

public static final java.lang.String ML7$ATTRIBUTE_NAME_STRING
Miscellaneous logical property of type ML7. Key name: ATTRIBUTE_NAME.

Description: What is the attribute for this role?

See Also:
Constant Field Values

ML4$WEIGHT_SCORE_INTEGER

public static final java.lang.String ML4$WEIGHT_SCORE_INTEGER
Miscellaneous logical property of type ML4. Key name: WEIGHT_SCORE.

Description: Score used for this weight if the attributes in the two match records are identical. Similarity will be used to generate this score.

See Also:
Constant Field Values

ML4$BLANK_SCORE_INTEGER

public static final java.lang.String ML4$BLANK_SCORE_INTEGER
Miscellaneous logical property of type ML4. Key name: BLANK_SCORE.

Description: Score if either attribute is blank

See Also:
Constant Field Values

ML4$WEIGHT_ATTRIBUTE_STRING

public static final java.lang.String ML4$WEIGHT_ATTRIBUTE_STRING
Miscellaneous logical property of type ML4. Key name: WEIGHT_ATTRIBUTE.

Description: Attribute

See Also:
Constant Field Values

ML1$KEY_NAME_STRING

public static final java.lang.String ML1$KEY_NAME_STRING
Miscellaneous logical property of type ML1. Key name: KEY_NAME.

Description: Name of the primary, foreign or unique key (primary, foreign, or unique).

See Also:
Constant Field Values

ML1$KEY_COLUMNS_STRING

public static final java.lang.String ML1$KEY_COLUMNS_STRING
Miscellaneous logical property of type ML1. Key name: KEY_COLUMNS.

Description: Local columns that define this key (Comma separated if more than one).

See Also:
Constant Field Values

ML1$KEY_TYPE_STRING

public static final java.lang.String ML1$KEY_TYPE_STRING
Miscellaneous logical property of type ML1. Key name: KEY_TYPE.

Description: Type of key - primary, foreign or unique.

See Also:
Constant Field Values

ML1$REFERENCED_KEYS_STRING

public static final java.lang.String ML1$REFERENCED_KEYS_STRING
Miscellaneous logical property of type ML1. Key name: REFERENCED_KEYS.

Description: If the key is a foreign key, this will contain the key or keys used of the referenced object.

See Also:
Constant Field Values

ML10$EXPRESSION_STRING

public static final java.lang.String ML10$EXPRESSION_STRING
Miscellaneous logical property of type ML10. Key name: EXPRESSION.

Description: Rank expression.

See Also:
Constant Field Values
Constructor Detail

PropDefMiscLogical

public PropDefMiscLogical()
Method Detail

getPropSheet

protected static oracle.owb.mapping.PropSheetImpl getPropSheet(java.lang.String type)
getPropSheet Retrieve the property sheet of a property type.
Parameters:
type - A property type.
Returns:
The property sheet of the type.

containsKey

protected static boolean containsKey(java.lang.String type,
                                     java.lang.String key)
containsKey is a boolean checkup to see if this set of property definitions includes the definition for the key.
Parameters:
type - A property type.
key - A property key.
Returns:
true - if this set of properties defines the key; false - if otherwise.

Oracle Warehouse Builder Java API Reference
10g Release 1 (10.1)

B12155-01

Copyright © 2003, Oracle. All Rights Reserved.