After reading "change-data-capture-another-way-to-implement-the-incremental-load2" article I have a simple question: Is it possible to use more than one "State name" for the same table? In this case, if I want to define more than one state into "cdc_states" table for the "employee" table, may I define CDC_State1, CDC_State2, and so on to feed unified data into more than one stagins tables? May I use this approach to feed data into different targets as different "processed ranges"?
Thank in advance if anybody can shed a light.