I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed out after 15 minutes. Is there any way to create parameterized view. For e.g. I will pass Year Parameter, let's say only 2002 to the derived view and select only sub set of the data not entire table. I would like to pass this parameter from Tableau to Denodo.
In short, Tableau will pass 2002 Year to Denodo. Denodo will return 2002 year records to Tableau, Not all 5 millions records.