You can add the capability to search for contracts, products
and categories by name, but without case-sensitivity restrictions.
You can still achieve very high performance search.
This is an optional feature that is only available when you first
install
InfoSphere® MDM.
Important: Once the feature is activated, some database objects
will be created, you can not deactivate it unless you re-install InfoSphere MDM.
Different platforms have different solution to achieve this goal:
- On DB2® for Linux, UNIX, and Windows,
if you have this enabled, the InfoSphere MDM code
will create derived columns for fields using an UPPER function,
which prefixes the field with U, and an index will
be created on the derived field. That column is used to store values
in upper case to facilitate searches. For example, the field SERVICE_ORG_NAME will
have a corresponding derived column USERVICE_ORG_NAME.
- On DB2 for z/OS® v9 and later, and Oracle, only an index
is created using the UPPER function.