Record Mapping

You should use the record mapping feature in a publish rule because:

• The published data comes from staging tables or temporary tables.

  Using staging tables is the only way to publish rows that have been deleted from application master tables.

• The published data needs an order sequence that differs from that of the records in the message.

• You must create a view that selects only current effective-dated rows in situations in which the application table is effective-dated and the subscribing database cannot process future-dated transactions.