> We can achieve Multiple values from Unconnected Lookup-Tr. We just need to override the default lookup sql query, there in one of the return port we can concatnate the values using ||.
> The concatnated multiple values will be returned from lookup to calling expression. In the expression we can extract / separate the concatnated string value (multiple values concatnated in lookup) and can pass to the target…
SELECT DEPT.DNAME||' '||DEPT.LOC as OUT_MUL_Values, DEPT.DNAME as DNAME, DEPT.LOC as LOC, DEPT.DEPTNO as DEPTNO FROM DEPT
> Before overrideing we should create one return port in the lookup-tr (here OUT_MUL_Values )
> Devide that OUT_MUL_Values in an expression
O_DNAME = REG_EXTRACT(OUT_MUL_Values,'(\w+)\s+(\w+)',1)
O_LOC = REG_EXTRACT(OUT_MUL_Values,'(\w+)\s+(\w+)',2)
> Connect to target...
So here we are getting Multiple values using Unconnected Tr.