topic Re: dynamic action on a table tDBOutput component in Talend Studio

dynamic action on a table tDBOutput component

Anonymous — Mon, 12 Aug 2019 15:47:17 GMT

Hy all

My question is :

It is possible to specify the action(Truncate table / Delete table if not existe ..) on a table tDBOutput dynamically with a variable context ?

The purpose of this job is :

-to register a new mode_exec context variable at the job level to configure the execution mode .
- mode_exec = INIT (initialization) allowing to make a truncate of a DW table before being loaded by a data file.
- mode_exec = INCR (incremental) forbidding to make a truncate of a DW table before it is loaded by a data file.

Any explication plz

Re: dynamic action on a table tDBOutput component

Anonymous — Tue, 13 Aug 2019 14:43:39 GMT

Hi,

You can use a Run if condition to control the flow. You can add the if condition statement within Run if path.

A simple scenario will be as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: dynamic action on a table tDBOutput component

Anonymous — Tue, 13 Aug 2019 14:51:21 GMT

Hi ,

@nthampi thank you for your answer .

Acually , i find this solution wich is not very different of yours :

Set up a tDBRow with instruction "Truncate TABLE " at the beginning of the job. Then put a condition the execution of this tDBRow component with a variable, in an "IF" link" :

In the IF link condition : "INIT".equals(context.mode_exec)

Re: dynamic action on a table tDBOutput component

Anonymous — Tue, 13 Aug 2019 14:54:18 GMT

@AsEls

Both are two options for the same query 🙂 Since you have got the details, could you please mark both posts as answers to the topic?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved