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.
if unconnected lookup on relational table