Hello, do the files in a change capture stage have to be identical in number of columns? I have the following situation...
before = FILE_A with columns COL_A, COL_B
after = FILE_B with columns COL_A, COL_B, COL_C
I need to compare only columns COL_A, COL_B which are identical in both tables, but to simplify down stream processing would like COL_C from the after table to simply be passed along in the output. How do i exclude COL_C from the compare, but include it in the output?