Data Warehousing Community Forum

ETL Tools => Informatica => Topic started by: Lianamelissa on January 02, 2019, 06:08:54 pm

Title: Informatica MDM OpenHandler
Post by: Lianamelissa on January 02, 2019, 06:08:54 pm

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>
<column.... columnUid="ChildTablename|ColumnType"...>
<column.... columnUid="ChildTablename|ColumnValue"...>
I checked multiple Informatica Support videos but can't come to 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?

Thank you.