Wednesday, 26 February 2014

Recuperating Bind Variable Values In ODI Jython Scripts

Is it possible to set up an ODI Specific Procedure and, using the bind mechanism, pass values from the Source tab to the Target tab Jython script? This is possible.
For example:
Command on Source tab (any Database technology):
select first 10 distinct to_char(d_evnm,'%m/%d/%Y') my_date
from <%=snpRef.getObjectName("L","<my_table>","D")%>
order by 1 
Command on Target tab (Jython technology):
s = '#my_date'
print s

This Specific Procedure will the call the Jython script for as many times as the number of values generated from the 'select' request. Each Jython script run will have its uniquely specific "mydate" value.

No comments:

Post a Comment