Connect to the Oracle --> Drag Custom SQL option to Datasource pane
Select * from
where date =<dateparameter>
Create a Date parameter in Tableau and use that parameter in the custom SQL. So that whenever you select the day, respective to that day data will be retrieved from DB,
Only thing is its a live connection it may take some time while loading the data, if your server configuration is very high like heavy bosted RAM, Processor then the performance will increase
Hope this helps kindly mark this answer as complete/helpful so that it will help others
Thanks for the reply.
How about using materialized view in place of table from oracle. what is your thoughts on this?
You can use that as well.