topic Re: Refresh Materialized View using Talend job in Talend Studio

Refresh Materialized View using Talend job

Anonymous — Tue, 29 Oct 2019 14:23:55 GMT

Hi ,

I have a requirement to Refresh the Materialized View after a Talend job has been completed successfully.

Please advise how to create a Talend job which does a complete refresh for Materialized view.

what components should be used? Is it possible to retrieve the Schema for materialized view?

Re: Refresh Materialized View using Talend job

Anonymous — Tue, 29 Oct 2019 14:47:16 GMT

This post talks about this requirement....

https://community.talend.com/t5/Design-and-Development/execute-statement-in-tOracleRow/td-p/78042

Re: Refresh Materialized View using Talend job

Anonymous — Tue, 29 Oct 2019 15:07:27 GMT

Hi rhall , Thank you for the Quick reply. I have the materialized view in Postgre DB. How to retrieve the Materialized view schema in Talend. If there is any reference job to show how to interact with Mview it will be helpful. Thanks

Re: Refresh Materialized View using Talend job

Anonymous — Tue, 29 Oct 2019 15:11:32 GMT

I don't have a Postgre DB I'm afraid. However this guide talks you through doing this and all you have to do is replace the code in the previous example I gave you...

https://www.postgresql.org/docs/9.6/sql-refreshmaterializedview.html