dynamic action on a table tDBOutput component

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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)

[Anonymous]

@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