Hi Talend Community,
I would like to execute a exec command to refresh a materialized view before executing a query on that view.
I get the error invalid sql statement when trying to execute the statement in Talend.(the query works in SQL developer)
The query looks like this in toracleinput:
with tbl1 as (
Any help would be appreciated
@mehmedie , can you execute in tOraclrow tat query and use on Component OK to tOralcinput execute your select query.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences