Update the mappings in FDMEE Custom tables
Hello Everyone -
I am working for a project where we used custom FDMEE schema table to load the data load mappings in FDMEE. If an yupdates in mappings occurred we are manually updating the mappings in the custom table.
Client wants to be done this process as automated. I have figured an Jython scripting to update the mappings in custom stage table.
How can we achieve this by using custom script in FDMEE.
Below is the script trying to use as custom script:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
import csv
mapReader = csv.reader(open('file.csv'), delimiter=',', quotechar='|')
cnt = 0
fdmAPI.executeDML("delete from fdmee_stage.xxbt_arm_profile_map",None,False)