Hi @Community Alums 
If the data is not being stored in the import set table and you are directly storing that in the normal table, then the transform map won't work.
You can use business rule / flow to create a copy of the record in the main target table. 
As a best practice, either push the data dircetly to the main target table OR push it to the import set table and then with the help of transofrm map you can load that to the main target table.

Regards,
Siva