Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have designed a simple job where I'm using tMap to insert new rows into Oracle table Table2. Most column values are basically taken from another table Table1.
tOracleInput (Table1) --> tMap --> tOracleOutput (Table2).
However, one column value (Column_Date) in Table2 is to be taken from a function with multiple parameters as shown below. This is where I got stuck.
Package_Name.Function_Name(
PARAM1 = Table3.columnX,
PARAM2 = Table1.ColumnY,
PARAM3 = "string_value1"
PARAM4 = Number,
PARAM5 = "string_value2",
PARAM6 = null,
PARAM7 = null)
Suggestions??
Thanks.
Did you try to use tOracleSP , to call the procedure and get the column value before updating.
https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/1gQHLDcbpjnw_HLOYcAcGA
I did, but it returns nothing. The examples I found are of functions with only one parameter or parameter has a set value instead of table column. Also some of the parameter values in my case are based on sql query (Select Col1 from Table1 when Table1.KeyCol=Table2.KeyCol)