Mapping to consolidate data (one-to-one)

If your business environment contains information that is scattered across different source tables, you may want to consolidate it to facilitate report generation, data management, or data security.

To merge different information about a common entity into a single row, such as a person, a customer, or a product part, map your source table to your target table using the Consolidation one-to-one mapping type.