The problem of FDMEE mapping script
Hi,I have a FDMEE mapping script problem.In Data Load Mapping -> Dimensions(Entity) -> Like,I created a mapping script,the following is code:
entity = fmdAPI.getString("ENTITY")
query = "SELECT TDATAMAP.TARGKEY FROM TDATAMAP,TPOVPARTITION WHERE TDATAMAP.PARTITIONKEY = TPOVPARTITION.PARTITIONKEY AND TDATAMAP.DIMNAME = 'ENTITY' AND TPOVPARTITION.PARTNAME = 'Loc_Dummy' AND TDATAMAP.SRCKEY = ?"
params = [entity]
queryResult = fdmAPI.executeQuery(query,params)
queryResult.next()
TARGKEY = queryResult.getString('TARGKEY')
fdmResult = TARGKEY
queryResult.close()
I have many Locations which also has Entity dimension mapping, it can share an Entity dimension mapping.I created Dummy Location,and other locations are using the Entity dimension mapping of Dummy Location which used mapping script to associated whit it.