Not sure if this question belongs in this section, but I would like to know how Denodo handles aggregate awareness. Does Denodo have the ability to be configured logically to pull from a single fact table, but physically have multiple tables at different grains - and know the best table to pull data from. For example, if I have tables fact_detail, fact_hour and fact_day the difference between the tables are that the detail table has a timestamp, the hour table has a date field and an hour field, and the day table only has a date field. If I write a query that sums by day, I want it to only query the day table and if I add the hour attribute it should query the hour table, etc.
Thanks.