is it possible to solve the following scenario:
I have two views with different sources, which I would like to join (a push-down is therefore not possible).
I want to join these views and make them available for reporting.
However, the reporting now only wants to query one column from this view.
Denodo executes this query on the correct source, but still pulls data from the other source to join it. Is it somehow possible to skip this join and actually run this one column without using the other source and without having to build a new view?
This would drastically increase my performance at least for this scenario.
However, I can also understand that this requirement may not be immediate, hence my question if this could not be switched on somehow.