preventing a column from update

[Denial]

Hi ,

Is there any option to prevent particular column from update

Target :- SQL 

Thanks,

[john_wang]

Hello @Denial ,

Thanks for reaching out.

Not very sure how the target table column was defined however there are different options:

1- Remove the column from table transformation then the column will not being updated

2- if the column has existing value and you want to keep it as is, then update the column with existing value by using target_lookup function. A very good sample : Target Lookup - Insert_Date 

Hope this helps.

Regards,

John.

[Jon_Donker]

Hi,

Do you mean if a particular column changes value - don't capture the change?

We have tasks like this that only capture changes for particular columns.  We have to add filters like the following in our tasks:

($AR_H_OPERATION != 'UPDATE') OR
(
  ($AR_H_OPERATION == 'UPDATE') AND 
  (
    ( $BI__COLUMN1 != $COLUMN1 ) OR ( $BI__COLUMN1 IS NULL AND $COLUMN1 IS NOT NULL ) OR ( $BI__COLUMN1 IS NOT NULL AND $COLUMN1 IS NULL ) OR
    ( $BI__COLUMN2 != $COLUMN2 ) OR ( $BI__COLUMN2 IS NULL AND $COLUMN2 IS NOT NULL ) OR ( $BI__COLUMN2 IS NOT NULL AND $COLUMN2 IS NULL ) OR
    /* We're not capturing changes on Column 3*/
    ( $BI__COLUMN4 != $COLUMN4 ) OR ( $BI__COLUMN4 IS NULL AND $COLUMN4 IS NOT NULL ) OR ( $BI__COLUMN4 IS NOT NULL AND $COLUMN4 IS NULL ) OR
    ( $BI__COLUMN5 != $COLUMN5 ) OR ( $BI__COLUMN5 IS NULL AND $COLUMN5 IS NOT NULL ) OR ( $BI__COLUMN5 IS NOT NULL AND $COLUMN5 IS NULL )
 )
)