This content has been marked as final. Show 5 replies
What I would do is creating a first temporary interface (yellow) with your lookup datastore as source and exactly the same columns in the target. On the flow tab, thick the "Distinct rows" checkbox.
Then in your other interface, where you have to choose your lookup table, click on the Interfaces tab instead of Datastore. Find your first interface and thick "Use Temporary Interface As Derived Table".
It should do what you want.
Thanks for your reply.
I've tryed, but the result is not satisfying, because using the temporary interface make ODI joins the tables outside the subquery, instead of inside.
I'll try to explain myself:
FROM SOURCE , (select distinct a4,field1 from temp_interface) t
Maybe I'm doing something wrong, but this way I need to specify in the temporaray interface both the field I need and the field to join the main table.
The problem is that the field used to join is not unique to the field I need for the select.
I forgot to tell you to thick the "SQL expression in the select clause" radio button on the last step of the lookup wizzard.1 person found this helpful
It tried and it works well for me.
now it behave EXACTLY like I needed.
Great. Thank you for the reward points ;).