Data Warehousing Community Forum
October 24, 2019, 01:22:30 am

  Show Posts
Pages: [1]
1  ETL Tools / Informatica / Informatica MDM OpenHandler on: January 02, 2019, 06:08:54 pm
Hello,

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 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.
Pages: [1]