Hello
Im working with CDC on AWS using Logminer. Im trying to see further cases where the option to include supplemental data beyond primary key is recommended. The remaining that im asking for is foreign key and all columns. Any reference for a more detailed case would be great
https://docs.aws.amazon.com/pt_br/dms/latest/sbs/chap-on-premoracle2aurora.steps.configureoracle.html
As far as i could see
Effects of ALTER TABLE ... ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS (supplemental_id_key_clause) (Doc ID 2067514.1)
It was not clear for me that the supplemental data is regarding the collection of the table data to applied on the replica, or if is just the search argument to find the specific row being manipulated
As far as i could understand the 'supplemental' is exactly that. Extra info that may be even be a repetition of all row data included/altered/delete , that is already in the log, that will be shipped to the CDC destination
Thanks