Use unique aliases

  • Recommendation: When you use the auto-map feature, we recommend that you select a single target table. We do not recommend using the auto-map feature to map at the data model level.

  • Rationale: Poor performance occurs when you auto-map more than one table at a time, and is worsened when you map to 10 or more tables at a time.

  • Additional information: To ensure the best performance when you auto-map, use the Column Mapping user interface, and use the Shift+Select keyboard shortcut to run auto-mapping only for columns in a single table that have known map matches.