Siebel Marketing Guide > External Data Mapping >

Working With Fields

When you add (map) a table to the Siebel Marketing Repository, you automatically have access to every field in the table as defined by the data source.

NOTE:  Because some databases such as Oracle do not support Unicode characters in their table names, we cannot support Unicode characters in table names and field names in the Siebel Data Warehouse.

When you map a character field to a numeric field, you need to convert the character field to a numeric field. This can be done using the to_number attribute. For example, to map substr(telephone,1,3) to SHORT in the Fields view, you need to set the to_number attribute in Expression as follows:

to_number(substr(telephone,1,3))

CAUTION:  If you do not convert these character fields, you might receive an error message (Error in Row).

The following topics are discussed in this section:


 Siebel Marketing Guide 
 Published: 23 June 2003