We are facing issues with multiple database hits, instead of one.
We have created a base table that pulls data from a data source.
There are multiple tables created which pull filtered data from the base table.
Ideally, the base table should fetch data from the data source once, and all other tables should get it from the base table.
Whats happens is, each time a table pulls data from the base table, the base tables hits the data source and gets the data from there. This adds to an overhead of base table fetching data from the data source multiple times when we refresh the data.
