I am having difficulting figuring out Oracle Data Integrator and how to filter an aggregate column,
for example - I am taking data from a source and aggregating it to a target. Within one of the target fields I would like to filter - here is the scenerio
total_cost = sum(quantity*unit_price)
total_cost_less_options = sum(quantity*unit_price) where option='N'
I am having difficulting for the mapping for total_cost_less_options in ODI interface, when I create the implementation I am not getting the syntax correct.