I am new to Denodo. I have installed Express edition on my laptop and running a sample task.
I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join statement between agents and Customer data it return 0 rows, until I cache Customer data.
Is there any way we can execute join statement between different sources without Caching, as It results replication cost?
both Virtual Plans (_PG Source_ , _MYSQL Source_ ) return some rows but Inner Join Plan results 0 rows.