Pass value from lookup table to a variable

SR2210 — Sat, 16 Nov 2024 03:25:47 GMT

Hi,

My talend job has to transfer data from one table (stg_1) in Postgres and load it to another table (pi_value_history_5m). To load it I will have to lookup for batch id in another table (ETLBatchID). This ETLBatchID table is auto incremented in which each time i lookup to it, the batch id will add 1. For example when i run the job now, the batch ID is 1. The next time i run the job, batch ID will be 2.

The problem is I have another subjob with the exact same process but the source is from a different table (stg_2). I need to run this job after the first job but I need it to have the same batch ID. Is there any way that I store the batch id value from the first subjob and pass it to the second subjob so I won't have to lookup to ETLBatchID twice? (as the batch ID will be incremented in for the second job)

Thank you

Re: Pass value from lookup table to a variable

TRF — Wed, 29 Jan 2020 10:37:26 GMT

If the ID is generated by the database, you need to query the associated table to get the value to be reused by the 2nd subjob

Re: Pass value from lookup table to a variable

Anonymous — Thu, 27 Feb 2020 08:04:23 GMT

Hi ! @TRF
How do we do this ? Because i have the same problem but i'm always bloqued.
NB: i'm a New in Talend

topic Pass value from lookup table to a variable in Talend Studio

Pass value from lookup table to a variable

Re: Pass value from lookup table to a variable

Re: Pass value from lookup table to a variable