Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI: Select fields after a JOIN

Guillem CaceresJan 25 2021

Hi,
I think it has a simple solution, but I have been unable to find the correct component to use in this situation.
I'm working in a Mapping with multiple tables to be joint in a final target table.
These tables have a lot of fields, and after using the join component on them, I would like to select only a few fields, to simplify the process and the next steps. Which is the correct way to achieve this?
I have been trying to use the SET and SUBQUERYFILTER components, but these expect two inpunts, and I would like to use only withe the join component as an Input.
Thanks for your time in advance.

Comments