topic Store a value in the cache and update it frequently in Talend Studio

Store a value in the cache and update it frequently

Anonymous — Sat, 16 Nov 2024 05:39:15 GMT

Hi,

When the talent job is run, I want to store a default value (ex: 1) in the cache. I've a table which contains only one row and column. Whenever there is an update in the row (ex:2), this value needs to be updated in the talend job cache. Can you let me know how to implement in Talend?

Dev

Re: Store a value in the cache and update it frequently

nfz11 — Thu, 06 Jun 2019 08:16:02 GMT

You could use the Talend component tHashOutpout to store the data and tHashInput to read it. See the documentation on these components here:

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/LTqBBurBnnkWIPVTY769dA

Re: Store a value in the cache and update it frequently

TRF — Thu, 06 Jun 2019 08:28:22 GMT

But records strored into a tHashOutput component cannot be updated.

As you have a single row to be cached, a simple global variable should be enough for your use case.

Re: Store a value in the cache and update it frequently

nfz11 — Thu, 06 Jun 2019 08:33:47 GMT

OK yeah, as @TRF said, if it is just one variable that you want to keep overwriting with the latest value of your column, you can use the globalMap to store it.

You can use the tSetGlobalVar component to do this:

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/xx0nz4uGJnqyc7dKOLN4Wg

You can also read or write to the globalMap in a tJavaRow component.