The API of the DM is documented in de installation directory. Using this API you can add the attributes to the entities.
There are several examples of transformation script on OTN.
Hey Joop thanks for your reply while I was trying the to import the document I'm facing the below issue.
I was not able to read the excel as there was no excel format in the odbc driver. Kindly suggest
I found the ODBC driver can you provide in which format I should create the excel? So tat the it can be imported
you can find a transformation script here: https://community.oracle.com/message/10109948#10109948
In this example there is a jdbc connection which you can replace with the reading of the excel file. And you have to replace the coding to work on entities.
Hope that helps.