create "internal" lookup table

[robvoi]

Hi,

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

So something like a job internal db/table.

[Anonymous]

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

[robvoi]

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.

[Anonymous]

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...

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