We are using CDC (change Data capture) in sql server 2008. In the "cdc.dbotablect" system generated table , Separate record for every operation ( $operation = 1 for Delete Record, $operation = 2 for Insert New Record and $operation = 3/4 for Before/After Update) is getting maintained. we want to maintain only records for __$operation = 1,3 and 4.
I don't need new record insertions in the CDC table. I'm enabling the CDC for the table like this
CDC is meant for capturing INSERT, UPDATE, DELETE operations, that means you cannot customize the operations.
To your second question, the better option will be creating views. i.e something like
Edit : only if your columns values are few.