When you want only one replication definition for a source table, and the source column names differ from their destination counterparts, use the column_name as replicate_column_name clause in the replication definition.
For example, for a source table named publishers1 and a destination table named publishers2, where the source column pub1_name corresponds to the destination column pub2_name, enter this:
create replication definition publishers_rep with primary at TOKYO_DS.pubs2 with primary table named publishers1 with replicate table named publishers2 (pub_id char(4), pub1_name as pub2_name varchar(40), city varchar(20), state char(2)) primary key (pub_id)
