Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Is there any option to prevent particular column from update
Target :- SQL
Thanks,
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.
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 )
)
)