CODEWITHSUNDEEP
oracle-data-integrator
Rajesh Kumar
Rajesh Kumar

Reputation: 59

How we can pass multiple values in ODI scenarion variables

Is there any way to pass the multiple values in odi scenario Variable.

I am attaching the screenshot for the reference.enter image description here

Upvotes: 0

Views: 1596

Answers (1)

user14809786
user14809786

Reputation: 11

See the Oracle function listagg. For example:

SELECT 
LISTAGG (
                  [col_value1] || ','
) 
WITHIN GROUP (
  ORDER BY      [col_date] desc
) AS            [col_alias] 
FROM            [table];

This would create list of values with comma in between. You could do a semicolon, comma, etc. You could place this in the Source Command feeding the Target Value, or just show it as immediate output in the Target Value.

Upvotes: 1

Related Questions