Error while creating ETL Map - "Datasource table already associated with an ETL Map"


Description

Creation of ETL Map only allows creation of new map only for import set tables are not being used.

Cause

Customer may have a lot of transform maps (in "sys_transform_map" table) already using existing data sources' import set table. ETL only allows to create new map if the data source's import set table is not being used.

Resolution

Check existing transform maps in sys_transform_map table. Mark the map which is using import set table as inactive if customer wants to create ETL Mapping.