Selective Update of Non-user Key Columns in Siebel

Selective Update of Non-user Key Columns Using NET CHANGE and ONLY BASE COLUMNS.

By judiciously combining the two IFB file parameters, selective null updates of Siebel base table columns can be carried out using Siebel EIM

Let us consider 3 non-user key columns Col 1, Col 2 and Col 3 in a Siebel base table. Columns 1 and 2 should not be updated with NULL while column 3 be updated with whatever is there in the corresponding EIM column (NULL or non-NULL value)

1. To achieve this, when the EIM column corresponding to Col 3 always has a NULL, the parameters should be set as below:
NET CHANGE = TRUE
ONLY BASE COLUMNS = COL 1, COL 2

2. If the corresponding EIM column (for Col 3) has a combination of NULL and non-NULL values, the job should be run in two steps with the parameters set as below:

Step 1
NET CHANGE = FALSE
ONLY BASE COLUMNS = COL 3

Step 2
NET CHAGE = TRUE
ONLY BASE COLUMNS = COL 1, COL 2