Input File You Can Use with the Case Insensitivity Wizard

The Case Insensitivity Wizard can accept a comma-delimited (.csv) file as input. Each line in the file is one record that defines one column that the wizard configures for a CIAI query. Oracle provides a recommended input file. The input files include a csv file extension and are located in the objects subdirectory of your Siebel Tools installation. These files list columns that Siebel CRM frequently uses for queries. You can edit these files or create new input files.

You must use the following format for each record:

TABLE_NAME,COLUMN_NAME,Method,Index Strategy,Operation

where:

• TABLE_NAME and COLUMN_NAME are required.

For example:

S_CONTACT,EMAIL_ADDR,Database,Copy All,On

The Case Insensitivity Wizard inserts the default value for any optional variable that you omit.

If you omit a variable from a record, then you must provide a delimiting comma that represents the placeholder for the variable. In the following example, the Index Strategy variable is omitted:

S_CONTACT,EMAIL_ADDR,Database,,On

The Case Insensitivity Wizard does not perform special handling for a denormalized column. To configure a CIAI query on denormalized columns, you must include them in an input file.

For more information, see Variables You Can Use with the Case Insensitivity Wizard.