Siebel tables can contain List of Values (LOV) columns. Each LOV column corresponds to the LOV type that contains a list of valid values for a specific language. You can specify an LOV language for a Siebel EIM Load transformation. The LOV language of the Siebel EIM Load transformation must match the LOV language of the Siebel tables.

When you create Siebel EIM Load transformation and select a Siebel EIM table, you import the metadata for the columns of that EIM table. If the metadata contains the LOV type, you can configure the session to validate the data for that column against the list of valid values based on the LOV type and the LOV language.

For example, the EIM table EIM_ACCOUNT contains a column ACCNT_TYPE_CD. The LOV type of this column is CUTP_ACCOUNT_TYPE, which contains the following valid values:

The LOV language for these values is English. When you load data into the EIM table, the PowerCenter Integration Service validates the data of the ACCNT_TYPE_CD column against these values. If the data of the column matches the values in the list, the PowerCenter Integration Service loads that data into EIM tables. Otherwise, it writes the erroneous rows into the ERROR output group of the Siebel EIM Load transformation.