I am about to added two columns to a table named PROCESSED_LINE. The columns currently exist on a table named MKT_CNTRY. I realize I could do a JOIN between these two tables, but one of the JOIN columns contains a size mismatch (MKT_CNTRY.PART_NUMBER CHAR(12) and PROCESSED_LINE.SHIP_PROD_ID CHAR(18)).
Anyway, I would like to duplicate the two columns to the PROCESSED_LINE table and maintain them over time with a trigger on the MKT_CNTRY table (the master table).
I should… Continue