How to return multiple values from unconnected lookup?

Question

In my mapping, I am using flat files as source and target. I have to use unconnected lookup. Can somebody tell me how to return multiple values from unconnected lookup specially when we are using flat files as source and target.

I know how to return multiple values when we use relational tables. In that case, we just concat values and return as single value. Again we split those values.

Please help me.

Answer 1

if unconnected lookup on relational table

1. In lookup override we can concatenate two or multiple ports and return that port to expression transformation.
   2. In expression transformation extract those values.