Five Stars

using tOracleRow to pre and post sql to source as well as target tables.

Is this possible to implement pre & post Sql on Source table and Target table in talend with main flow.

 

3 REPLIES
Twelve Stars

Re: using tOracleRow to pre and post sql to source as well as target tables.

I'm not entirely sure whether this is the response you are after, but Talend provides the tPreJob and tPosJob components for processes that need to take place before and after the main flow. The tPreJob will ensure that whatever is connected is run before the main flow. The tPostJob is a bit more special since this will always run at the end, even if there has been an error in the main flow. This can be REALLY useful.

Rilhia Solutions
Five Stars

Re: using tOracleRow to pre and post sql to source as well as target tables.

hii yes its an alternative solution. but i want to perform presql on target table with main flow.

Twelve Stars

Re: using tOracleRow to pre and post sql to source as well as target tables.

The just carry out that query in a subjob prior to your main query. For example....

PreQuery
    |
(SubjobOk)

   |
Start of main subjob
   |
(SubjobOk)

   |

PostQuery


Rilhia Solutions