01-04-2019 01:06 AM - last edited on 01-04-2019 05:55 AM by cjervis
I have to develop java code to interact with Informatica MDM tool for the following:
Implement beforeOpen(CustomizableBDDObject ob) method of IOpenOperationPlugin with a custom java code to lookup an attribute of a child object. BDDConfig.xml :
<subjectArea name="Subjectname" ...> <primaryObject ...></primaryObject> ... <one2ManyChild...name="Childname"..> <layout..> <column.... columnUid="ChildTablename|ColumnType"...> <column.... columnUid="ChildTablename|ColumnValue"...> .. </one2ManyChild>
I checked multiple Informatica Support videos but can't come to an appropriate solution.
Need to call an SQLServer Scalar function from my java code and use the returned value in my code. I am concerned about hardcoding credentials in the code + how to use different DB connection properties based on the deployed environment? Will Informatica internally handles DB connection properties?
Note: Restrictions informed to me to do above change: Have to provide a single jar file with above functionalities. My personal gut to an optimized solution that provides more scalability.
Informatica version 10.1.2
web container JBoss 7.5