topic Re: create "internal" lookup table in Talend Studio

create "internal" lookup table

robvoi — Sat, 16 Nov 2024 03:54:19 GMT

Hi,

is it possible to create a table for lookups without an input?

So something like a job internal db/table.

Re: create "internal" lookup table

Anonymous — Fri, 06 Dec 2019 19:41:43 GMT

Hi,

Could you please elaborate your use case? Why are you creating an internal lookup table?

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: create "internal" lookup table

robvoi — Mon, 09 Dec 2019 06:11:24 GMT

I have two (MSSQL) database tables. Based on a key I want to add Information which isn't in the database. But I do not want to extend the database and do not want to use external files.
So the information/table should be stored in the job.

Re: create "internal" lookup table

Anonymous — Tue, 10 Dec 2019 19:24:34 GMT

Hi,

If you are trying to store the data on temporary basis in memory, you can use Hash components available in Talend.

Below link can give you details about the component.

https://community.talend.com/t5/Migration-Configuration-and/Where-are-the-tHashInput-and-tHashOutput-components/ta-p/309

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