How to Concatenate Values Of 2 ODI Variables in ODI ?

ODI Interview Questions and Answers:

We can use SQL query to concatenate using || symbol for two variables.


select '#PROJ1.VAR1'||'#PROJ2.VAR2' from dual.