Q&A BY TAG 'Data Movement'

I have configured one of my views to use Data Movement and create temporary tables on one of my SQL Data Sources (using jdbc drivers). The view executes correctly, but the tables created on the data source are not being cleaned up after the view compl...

Data Movement

My question is regarding data movement without using the CONTEXT (DATAMOVEMENT) clause. I've been working with data movement to improve performance in a query using a view with a large amount of data joined to a view with a much smaller amount of data...

Data Movement

Hi , I have Denodo version 7.0.20181011. I have problems with the data movement and with the cache. once the cache is enabled on a DV everything runs correctly but the record is not in a validated state? how come? I also wanted to know if with the da...

Data Movement Cache

Hi, what is the difference between data movement to source vs data movement to view ? I found that my execution time reduced in case of data movement to view. Is it situational or is it always more performance efficient compared to data movement to ...

Data Movement

Good Morning Team, I'm working on a project where we had to enable data movement for optimizing the performance. There are times, the data movement is failing for some reason. The issue is that the front-end users do not have an idea if the data movem...

Data Movement Error Handling Data Movement Failure

Hello, I have a Derived View which contains multiple joins to other Derived and Base Views. The Base Views are sourced from individual Excel files. The Derived Views are derivations and joins on those Excel files. I wanted to turn on the Data Movement...

Data Movement

At present, I’m consuming data from a PostgresDB and looking to write to another PostgresDB using the below statement, however it returns an error stating the ‘Virtual Data Port does not support data movements to data source’ and lists a number of supp...

Data Destination Data Source PostgreSQL Data Movement