Refresh Materialized View using Talend job

[Anonymous]

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? 

[Anonymous]

This post talks about this requirement....

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

[Anonymous]

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

[Anonymous]

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