Hi Support Team.
I am trying to restrict the query to fire different data sources for increase the performance. given below is the bussiness requirement details
There is 3 different sources(ex. SOURCE1, SOURCE2 and SOURCE3), we created 3 different view(View1, View2 and View3) on top of all 3 data sources and added new field called "Source_Name" in all three view respectively that holds the view source name(SOURCE1, SOURCE2 and SOURCE3).
Then finally we created the business view(Final_View) by UNION all three views(View1 union View2 union View3).
Requirement is If user is querying the data by "select * from Final_View where Source_Name = 'SOURCE1';" then Denodo query should not try to hit the other two data sources(SOURCE2 and SOURCE3). it sould hit only the SOURCE1 data source.
Same as if user is querying the data by "select * from Final_View where Source_Name in ( 'SOURCE1','SOURCE2');" then Denodo query should not try to hit the SOURCE3 data source. it sould hit only the SOURCE1 and SOURCE2 data source.
Your help would be greatly appreciated.