ETL and Data Integration tools - Modern ETL software for everyone

I want to be able to restrict what records get updated in my Target Table. Currently, VI only lets you specify a table as a target to update and enter new fields.

I have this table where I only want to update fields based on setting of flag field (bit type) I created. I don't want to update every record. I was wondering if there a filter or other kind of setting I can do to limit the update to my table.

Only work around I have right now is to use a load table (as my Target Table), load all records there, delete the records I don't want to be updated and then proceed to update my actual target table.

I want to see if there is an easier way. Thanks.

I guess if flag field is true you want to update the record of false you do not?

That flag field is it in source table/file or in target table?

Mike

That is correct. On my target table, I have a flag which determines whether or not I should update that field using data from Source.

That is actually very easy thing to do.

1 Set transformation type to Update records.
2 Set for your flag field Mappping to Calculated
3 Enter 1 into calculation edit box (1=true,0=false)
4 Specify update key,
it must also include you flag field.

For example if you are loading list of orders.
PK for orders table is ORDER_NO field.
So the update key would be ORDER_NO+flag field

Please Let us know the outcome
Mike